Add where statement to Many-to-Many relation

In your many-to-many relationships, you can add where statements to your pivot table using the wherePivot method.

class Developer extends Model
{
// Get all clients related to this developer
public function clients()
{
return $this->belongsToMany(Clients::class);
}
 
// Get only local clients
public function localClients()
{
return $this->belongsToMany(Clients::class)
->wherePivot('is_local', true);
}
}

Tip given by @cosmeescobedo

Recent New Courses