How to add query on relational data in laravel?

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11

// User.php
public function posts()
{
    return $this->hasMany(Post::class);
}

// Post.php
public function user()
{
    return $this->belongsTo(User::class);
}

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13

$user = User::find($userId);

// Get all posts for a specific user
$posts = $user->posts;

// Get all posts for a specific user where the post has more than 100 likes
$posts = $user->posts()->where('likes', '>', 100)->get();

// Get all posts for a specific user with the user's name
$posts = Post::select('posts.*')
    ->join('users', 'posts.user_id', '=', 'users.id')
    ->where('users.id', $userId)
    ->get();