In what tables are users membership details stored

Hi ,

I need to retrieve the following info in relation to membership pro :

1. User ID
2. UserName
3. Status of membership(whether active or inactive)
4.Membership types associated with a user

In what tables are those details found

Thanks