alias('a') ->join('userinfo b','b.user_id = a.user_id') ->where($condition) ->order($order) ->paginate($page, false, ['query' => request()->param()]); $this->page_info = $user_list; return $user_list->items(); } else { return db('user')->where($condition)->order($order)->select(); } } /** * 取单个用户 */ public function getUserInfo($user_id) { $userinfo = db('user') ->alias('a') ->join('userinfo b','b.user_id = a.user_id') ->where('b.user_id',$user_id) ->find(); return $userinfo; } }