MySQL joint Query

Select. 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 =. user_id # Lite version: 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