mysql 多表查询

SELECT
        a.id,
        a.user_name,
        a.user_mobile,
        b.area_name,
        d.is_all_true,
        d.count
FROM
        ( SELECT c.is_all_true,c.count,c.user_id FROM 
                ( SELECT is_all_true,count,user_id FROM answer_record WHERE rounds = 1  ORDER BY count DESC LIMIT 2000 ) c
            GROUP BY c.user_id ) d
LEFT JOIN
        ( join_user as a LEFT JOIN area as b ON a.area = b.id )
ON a.id = d.user_id