hc_live/application/api/model/GroupModel.php

<?php
/**
 * Author: luzheng.liu
 * Time: 2020/12/5 19:52
 */

namespace app\api\model;

class GroupModel extends BaseModel {

    protected $table = 'group';

    public function getGroupList() {
        $count = $this->alias('g')
            ->join('group_role gr', 'gr.group_id = g.id');
        $select = $this->alias('g')
            ->field('g.*')
            ->join('group_role gr', 'gr.group_id = g.id');
        return $this->joinModelPageList($count, $select);
    }
}