select a.wl_num,a.parent_id,GROUP_CONCAT(b.cat_name,' ',a.cat_name) as lb,a.rate,a.rate_hot,sum(a.rate+a.rate_hot/100) as moq_rate from golon_ics_category a left join golon_ics_category b on a.parent_id=b.id where a.mpn_bm='golon_wfl'

封装：

描述：