MySQL Query For Emails

You could use

SELECT user_email FROM wp_users;

where wp_users is the name of user table and you’d have to replace the wp_ with the Prefix for each blog.