alias('r') ->field('r.*,u.nickname,u.avatar') ->leftJoin('user u', 'u.uid = r.uid') ->where($where); $totalCount = $query->count(); $list = $query ->order('r.id', 'desc') ->page($page, $pageSize) ->select() ->toArray(); return [ 'list' => $list, 'totalCount' => $totalCount, 'pageSize' => $pageSize, 'page' => $page ]; } }