Laravel - 加入评论，帖子和用户

Question

I'm trying to return every posts with each one's author, and also every post's comments with it's author. this is what i did:

The controller:

$posts = Post::with('comments', 'user')->latest()->paginate(3);

The Post model:

public function comments() {
    return $this->hasMany('App\Comment');
}

public function user() {
    return $this->belongsTo('App\User');
}

The Comment model:

public function users() {
    return $this->hasOne('App\User');
}

This returns every post with their authors and the comments but not the comment's author.
what else should i do??

Answer 1

Your Comment model:

public function users() {
    return $this->hasOne('App\User');
}

Implies that a user entry in database would have a comment_id field. But instead it should really have a user_id field in the comments database table:

public function user() {
    return $this->belongsTo('App\User');
}

Now you can eager load authors of comments as well:

$posts = Post::with('comments.user', 'user')->latest()->paginate(3);