with T_EXPERT as (select E.EXPERT_ID_, E.COM_CODE_, E.COM_NAME_, E.EMP_NAME_, E.STATUS_, ER.PARENT_PRO_CODE_, ER.PRO_CODE_ from MP_EXPERT E inner join MP_EXPERT_RELATION ER on ER.EXPERT_ID_ = E.EXPERT_ID_ and ER.PARENT_PRO_CODE_ is not null
)select T_EXPERT.EXPERT_ID_, COM_CODE_, COM_NAME_, EMP_NAME_, STATUS_, (select wm_concat(distinct
PARENT_PRO_CODE_) from T_EXPERT T where T.EMP_NAME_ =
T_EXPERT.EMP_NAME_) as PARENT_PRO_CODE_, (select wm_concat(PRO_CODE_)
from T_EXPERT T where T.EMP_NAME_ = T_EXPERT.EMP_NAME_) as
CHILD_PRO_CODE_ from T_EXPERT group by T_EXPERT.EXPERT_ID_,
T_EXPERT.COM_CODE_, T_EXPERT.COM_NAME_, T_EXPERT.EMP_NAME_,
T_EXPERT.STATUS_
