?$sql="select?a.id,a.area\_title,a.area\_type,a.max\_limit,
????????????(select?GROUP\_CONCAT(d.device\_name)?from?kc\_device?as?d?where?FIND\_IN\_SET(d.id,a.device\_id))?as?device\_name,
????????????(select?GROUP\_CONCAT(dep.dep\_name)?from?kc\_department?as?dep?where?FIND\_IN\_SET(dep.id,a.dep\_id))?as?dep\_name
????????????from?kc\_area?as?a";????
????????????$list=Db::query($sql);
結果如下
