拉拉维尔分页，只有第一个结果

Question

我对Laravel有点陌生，所以我希望这个问题足够清楚。

我有一个包含用户的表和另一个包含任务的表。

在我的用户模型中，我有以下内容：

public function tasks() {
return $this->hasMany('AppUser' , 'id');
}

我可以执行以下操作来从数据库中检索单个用户

$users = AppUser::find(1)->tasks()->paginate();

但我得到

{"current_page":1,"data":[{"id":1,"name":"Ed","email":"[e-mail]","email_verified_at":null,"created_at":null,"updated_at":null,"tasks":[{"id":1,"name":"Ed","email":"[e-mail]","email_verified_at":null,"created_at":null,"updated_at":null}]},{"id":2,"name":"Alyse","email":"[e-mail]","email_verified_at":null,"created_at":null,"updated_at":null,"tasks":[]}],"first_page_url":"http://127.0.0.1:8000?page=1","from":1,"last_page":1,"last_page_url":"http://127.0.0.1:8000?page=1","next_page_url":null,"path":"http://127.0.0.1:8000","per_page":15,"prev_page_url":null,"to":2,"total":2}

我也试过：

$users = AppUser::with(['tasks' => function($q) {
$q->first();
}])->paginate();

但任务属性为空

我的问题是我如何获得所有用户，但只有第一个任务并分页工作？

任务表

1   id(Primary) bigint(20)      UNSIGNED    No  None        AUTO_INCREMENT
2   created_at  timestamp           Yes NULL        
3   updated_at  timestamp           Yes NULL        
4   task_name   varchar(255)    utf8mb4_unicode_ci      No  None        
5   user_id(Index)  bigint(20)      UNSIGNED    No  None        

Answer 1

模型关系定义不正确。 您已将一个用户与多个用户关联。
https://laravel.com/docs/master/eloquent-relationships#one-to-many

public function tasks() {
// a User ($this) has many Tasks
return $this->hasMany('AppTask');
}

此外，使用->first()时要小心，因为除非指定，否则无法保证订单。

$users = AppUser::with(['tasks' => function($q) {
// get the most recently created task
$q->latest()->first();
}])->paginate();

Answer 2

另一个例子

$getData = $User::where('code_transaction',$code)->first();
$pag = $getData->paginate(10);