Relationship between three tables - additional information

I have a problem in Laravel.

I have 3 models:

Thread - fuser_id Post - thread_id, fuser_id User - id

I want to get the last post that was created for a given thread and information about the user who wrote it.

Model Thread:

public function lastpost()
{
		return $this->hasOneThrough(Post::class, User::class, 'id', 'fuser_id', 'fuser_id', 'id);
}

Controller:

$threads = Thread::where('category_id', $categories->id)->with('lastPosts')->get();

Receives user ID information, but needs more information, which is in the database.

Best Answer

Level 55

public function lastPost()
{
    return $this->hasOne(Post::class)->latestOfMany();
}

and to get it with user details

$threads = Thread::where('category_id', $categories->id)->with('lastPost.user')->get();

assuming Post model hass defined user relationship

1 like

Level 1

Level 55

@damian0021 you're welcome! To close conversation mark response as the best answer if it solved your problem

Please or to participate in this conversation.