分组字符合并

select  A.xj_area_id,A.xj_area_name,A.code,B.personname from (select elearea.xj_area_id,elearea.xj_area_name,wm_concat(ele.code) code from  bus_elearea_info  elearea
left join bus_area_ele_link  areaele on elearea.xj_area_id = areaele.xj_area_id
left join bus_eleinfo ele on areaele.ele_id = ele.ele_id
group by elearea.xj_area_id,elearea.xj_area_name) A
left join (select elearea.xj_area_id,elearea.xj_area_name,wm_concat(person.person_name) personname from  bus_elearea_info  elearea
left join bus_xjarea_person_link areaperson on  areaperson.xj_area_id = elearea.xj_area_id
left join sys_person person on areaperson.person_id = person.person_id
group by elearea.xj_area_id,elearea.xj_area_name ) B on A.xj_area_id = B.xj_area_id