// 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();
