Below query was ran in Oracle. SO if you are using MySQL you would have to change db parameters to td.

SELECT
user_name,
full_name,
email,
us_is_active
FROM
qcsiteadmin_db.users qu, _db.users pu
WHERE
pu.us_username = qu.user_name
AND
qu.us_is_active = 'Y'