GROUP_CONCAT

最新推荐文章于 2022-12-27 23:21:21 发布

安徒生_

最新推荐文章于 2022-12-27 23:21:21 发布

阅读量217

点赞数

CC 4.0 BY-SA版权

分类专栏：基础知识文章标签： sql thinkphp

本文链接：https://blog.youkuaiyun.com/u012439977/article/details/76695742

基础知识专栏收录该内容

20 篇文章

订阅专栏

// sql
SELECT a.*,GROUP_CONCAT(c.pri_name) pri_name 
FROM role a 
LEFT JOIN role_privilege b ON a.id=b.role_id 
LEFT JOIN privilege c ON b.pri_id=c.id 
GROUP BY a.id;

// thinkPHP
$data['data'] = $this->field('a.*,GROUP_CONCAT(c.pri_name) pri_name')->alias('a')
                     ->join('LEFT JOIN role_privilege b ON a.id=b.role_id
                             LEFT JOIN privilege c ON b.pri_id=c.id')
                     ->where($where)->group('a.id')->limit($page->firstRow.",".$page->listRows)->select();