laravel relationship

1use Illuminate\Database\Eloquent\Builder;
2
3// Retrieve posts with at least one comment containing words like foo%...
4$posts = App\Post::whereHas('comments', function (Builder $query) {
5    $query->where('content', 'like', 'foo%');
6})->get();
7
8// Retrieve posts with at least ten comments containing words like foo%...
9$posts = App\Post::whereHas('comments', function (Builder $query) {
10    $query->where('content', 'like', 'foo%');
11}, '>=', 10)->get();

1Event::with(["owner", "participants" => function($q) use($someId){
2    $q->where('participants.IdUser', '=', 1);
3    //$q->where('some other field', $someId);
4}])

1use Illuminate\Database\Eloquent\Builder;
2
3// Retrieve posts with at least one comment containing words like code%...
4$posts = Post::whereHas('comments', function (Builder $query) {
5    $query->where('content', 'like', 'code%');
6})->get();
7
8// Retrieve posts with at least ten comments containing words like code%...
9$posts = Post::whereHas('comments', function (Builder $query) {
10    $query->where('content', 'like', 'code%');
11}, '>=', 10)->get();

1For example, a blog post may have an infinite number of comments. And a single
2comment belongs to only a single post  
3
4class Post extends Model
5{
6    public function comments()
7    {
8        return $this->hasMany('App\Models\Comment');
9    }
10}
11
12class Comment extends Model
13{
14    public function post()
15    {
16        return $this->belongsTo('App\Models\Post');
17    }
18}

1$comment = Post::find(1)->comments()
2                    ->where('title', 'foo')
3                    ->first();

1$model->relation; // result of the relation, ie. null/model for x-1 relations or collection for x-m
2$model->relation(); // relation object
3