Skip to main content
Quick Tip

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

Enjoyed This Tip?

Get access to all premium tutorials, video and text courses, and exclusive Laravel resources. Join our community of 10,000+ developers.