SELECT userid,username, concat('【',group_concat(cardid_all ORDER BY cardid_all separator '】【'),'】') AS cardid_all FROM reports.upper_report_detail WHERE reports.upper_report_detail.rep_id ='4626' GROUP BY userid
|
||||||||||
棚号 | 姓名 | 环号 | ||||||||
011767 | 郝广乐 | 【0440402】【0440406】【0440408】【0440409】【0440414】【0440416】【0440418】【0440419】【0440420】 | ||||||||
012220 | 李宁 | 【0440873】【0440879】【0440880】【0440886】【0440888】 |