select * from wp_blogs
From the output of the command note down the
blog_id you want the users of. For eg: say you are wanting the users of the site with blog_id = 2 , next run the following query.select * from wp_users u join wp_usermeta um on u.id=um.user_id where um.meta_key="wp_2_capabilities"
REF : https://stackoverflow.com/questions/27495552/how-to-get-users-who-belong-to-a-wordpress-multisite-blog-site-with-sql
