php - Laravel: pivot table extra field in model

Solution:

You can still search on thepivot table using therelationship you have defined between aUser andCountry. If for the sake of this example we call that relationshipcountries and that you want to find people with the following$criteria (sticking to your example):

$criteria = [
    'canada' => 1,
    'uk' => 2,
    'france' => 3,
    'new zealand' => 4,
];
Copy code

So thekey in the above is theCountry and thevalue is thetype.

To findUsers that have those exact requirements, you could do the following:

$users = User::whereHas('countries');

collect($criteria)->each(function ($type, $country) use ($users) {
    $users->whereHas('countries', function (Builder $query) use ($type, $country) {
        $query->where(['name' => $country, 'type' => $type]);
    })->get();
});
Copy code

Then do something with your$users.

$users->get();
Copy code

Solution:

You can the country relationship ofHasMany

So, in users it would be this

public function countries() {
     return $this->hasMany('country_user_class', 'foreign_key_id_here')->latest()->take(4); // take 4 since the user can have 4 countries
}
Copy code

The query would look something like this.

User::whereHas('countries', function($query) {
    $query->where('type', [1,2,3,4]);
})->get();
Copy code

This would give you the result. This is how you can achieve it using Query. Such a problem can always be solved by Query. Let me know if you've any more question regarding this.