I want to go into my wordpress MySQL and generate a report of all the users in my database. I basically want to mimic what is done in users.php in wp-admin.
Does anyone know the query to do this? I cannot figure it out. I just want to username, name, email and role, and domain of blog they are assigned to (if possible)