where($where); $totalCount = $query->count(); $list = $query ->order('sort', 'desc') ->order('id', 'desc') ->page($page, $pageSize) ->select() ->toArray(); return [ 'list' => $list, 'totalCount' => $totalCount, 'pageSize' => $pageSize, 'page' => $page ]; } /** * 获取树形分类 * @param int $pid * @return array */ public function getTree($pid = 0) { $list = $this->where('pid', $pid)->order('sort', 'desc')->select()->toArray(); foreach ($list as &$item) { $children = $this->getTree($item['id']); if (!empty($children)) { $item['children'] = $children; } } return $list; } }