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); } }