Mysql 聯集查詢

SELECT a.real_name,b.* FROM (account_profile a) INNER JOIN(SELECT t.real_name,t2.* FROM (account_profile t) INNER JOIN(SELECT id AS err_id, catalog_id,type,status,content,add_user_id,phone_number,add_date,manage_user_id FROM catalog_error WHERE status=1 OR status=2)t2 ON t2.add_user_id=t.user_id ORDER BY add_date DESC) b ON b.manage_user_id=a.user_id#精簡版：select t2.real_name as add_name, t3.real_name as manage_name,t.* from catalog_error t join account_profile t2 on t.add_user_id=t2.user_id join account_profile t3 on t.manage_user_id=t3.user_id