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 ='15824' GROUP BY userid
|
||||||||||
棚號 | 姓名 | 環號 | ||||||||
900023 | 凱翔寄養棚 | 【1200391】【1200392】【1200393】【1200395】 |