SELECT mu.user_id, mu.username, mu.firstname, mu.lastname, ac.dob, ac.state, ac.zip, ac.homephone, if( c.class = 'owner', (


SELECT GROUP_CONCAT( sm.username )
FROM MASTER_USER sm
INNER JOIN circles sc ON ( sm.user_id = sc.user_id
AND sc.class = 'member' )
WHERE sc.circle_id = c.circle_id
AND sm.is_deleted = '0' ) , if( c.class = 'member', mu.username, '' )
) AS member
FROM `master_user` AS mu
INNER JOIN accounts AS ac ON ( mu.user_id = ac.user_id )
LEFT JOIN circles AS c ON ( mu.user_id = c.user_id )
WHERE mu.is_deleted = '0'
GROUP BY mu.user_id