Laravel 5.6 - eager load depending on value in parent table

Post.php

$fillable = ['id','flag'];

public function tags() 
{
  return $this->belongsToMany('App\Tags')->withPivot('pivot_flag';
}

public function flaggedTags()
{
  return $this->tags()->withPivot('pivot_flag');
}

Tag.php

$fillable = ['id']
public function posts() 
{
  return $this->belongsToMany('App\Post');
}

Pivot table post_tag columns: post_id,tag_id,pivot_flag

I need to fetch Post with Tags:

Post::select('id','flag')->with('tags')->find($postId);

However, if the flag is set to 1 in Post then I only want tags which have pivot_flag value in pivot table post_tag set to 1

So in that case I'd have following:

Post::select('id','flag')->with('flaggedTags')->find($postId);

How can I do this in single query? I could always do one query to check if the Post is flagged or not and then run the appropriate query for Tags, but that seems wasteful.

Eloquent or raw MySQL queries are welcome.

Thanks!

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/2P4hIjR
via IFTTT