select a.wl_num,a.parent_id,GROUP_CONCAT(b.cat_name,' ',a.cat_name) as lb,a.action_name,a.rate,a.rate_hot,ROUND(sum(a.rate+a.rate_hot/100),4) 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' array(1) { [0]=> array(7) { ["wl_num"]=> string(4) "1999" ["parent_id"]=> string(1) "0" ["lb"]=> NULL ["action_name"]=> NULL ["rate"]=> string(5) "1.105" ["rate_hot"]=> string(12) "选择利率" ["moq_rate"]=> string(6) "1.1050" } }

封装： -

描述：