The default naming convention of Laravel many-to-many pivot table is xxxxx_yyyyy, where "xxxxx" and "yyyyy" are names of related tables, in singular form, in alphabetical order.
Example: pivot table between users
and locations
should be called location_user
.
The wrong names would be location_users
(because it's not singular) or user_location
(because "user" and "location" is not in alphabetical order).
If you follow those naming conventions, you can define the belongsToMany relation without extra parameters:
app/Models/User.php
public function locations(){ return $this->belongsToMany(Location::class);}
If you name this table differently, you need to pass its name as a second parameter:
public function locations(){ return $this->belongsToMany(Location::class, 'users_locations');}
Why the following does not work?
Table 1: businesses
Table 2: business_tags
Pivot Table: business_business_tag
Probably Laravel misinterprets some repeating word differenly, not sure.
You can specify that table as the second parameter in your pivot function in the Model.
Or, if I were you, I would rename tables differently, it's quite confusing.