这里一个人负责多个地区,会产生多行,用 GROUP_CONCAT ,使用‘,’分割合并成一行 $data=Db::query(" select a.id,a.username,a.xingming,a.bumen,a.level,j.name,GROUP_CONCAT(dq.diquname) as diqu,GROUP_CONCAT(dq.diqu) as diquid from tp51_admin a left join tp51_juese j on a.level=j.jueseid left join tp51_dqid d on a.id=d.dqid left join tp51_diqu dq on d.diqu=dq.diqu GROUP BY d.dqid order by a.id ");
搭配group by 使用