Hello! I'm looking to create an Author Listings page on child sites to list the users of only the respective site. Naturally the issue with Multisite is that the following query will list all users in the network since WPMU has one user table:
$authors = $wpdb->get_results("SELECT ID, user_nicename from $wpdb->users WHERE display_name <> 'admin' ORDER BY display_name");
I'm told I need to add a blog ID in the above; but I'm not sure what that syntax should look like. I've tried digging through the database to understand the data structure better, but I can't seem to find where specific users are "assigned" or given permissions on a child site, so I'm having trouble figuring out what this query should be!