mysql 结果集

      select
        (SELECT GROUP_CONCAT(NAME) FROM hsb_user_type WHERE FIND_IN_SET (id,a.user_type_id)) AS typeName,
        a.* ,
        e.job_id as jobId,e.province_id as provinceId,e.city_id as cityId,e.area_id as areaId,e.company as customerName,
        u.real_name as realName
        
        from hsb_user a
        left join hsb_user_baseinfo e on e.user_id = a.user_id and e.enable_flag = 1
        left join hsb_user_assign d on d.user_id = a.user_id  and d.enable_flag = 1
        left join jdnew_system_user u on u.user_id = d.contact_id and u.enable_flag = 1