How I could consult Table users SQL?

Hello,

I would like to know how I can find user data in the tables, say where they are going and how I could consult? I’m using Paid Membership PRo and Sensei LMS, they are two different plugins, I would like for example to be able to show membership data and course data, for example I can see user and association data:

SELECT users.*, members.membership_id, level.name 
FROM wp_users AS users 
JOIN wp_pmpro_memberships_users AS members 
ON users.ID = members.user_id 
JOIN wp_pmpro_membership_levels AS level 
ON members.membership_id = level.id 
WHERE members.status = 'active'

but I would like to see only the user name, email, name of the association, name of the course and if it was approved.

How can I put this together in a consultation?