input('limit', 10); $page = $request->input('page', 1); $offset = ($page - 1) * 10; $user = \user(); $lists = User::withCount('child') ->withCount('childOrder') ->withSum('childOrder','income') ->where('parent_id', $user->id) ->limit($limit) ->offset($offset) ->get(); /* @var User $list*/ foreach ($lists as $list){ $list->become_child_at = Carbon::parse($list->become_child_at)->toDateString(); $list->child_order_sum_income = $list->child_order_sum_income ? : 0; $list->child_order_count = $list->child_order_count ? : 0; } return $this->success($lists); } }