Which SQL table contains the users of main site in WordPress multisite?

Question

I'm looking for the SQL table in WordPress Mutlisite which contains all users of it.

When I click on this number, I get the list of users of main site. Where is the table which contain this info?

Answer 1

This information is spread over tables wp_users and wp_usermeta.

wp_users contains basic information such as the user login, email, registered datetime and status.

The rest of the information is available in wp_usermeta, that uses the classic key/value format of Wordpress.

References:

• https://usersinsights.com/wordpress-user-database-tables/
• https://wordpress.stackexchange.com/questions/5628/what-are-the-differences-between-wp-users-and-wp-usermeta-tables
• see also this resource, which provides a handy query to gather user information from both tables