Laravel: Loading nested relationship only for related model

Question

I am trying to implement a feature and I don't think it's available by relationships.

A User may have many Companies and Company may have many Users. They are connected via company_employees pivot table.

pivot table looks like this:

company_id, user_id, position_id

I want to have an option to fetch company employees with their assosiated position.

Let's say there are companies:

"Foo Company"
"Bar Company"

and user

"John Doe"

There are also 2 positions:

"Frontend Developer"
"Backend Developer"

John Doe is an employee in both of these companies with different position.

company_id | user_id | position_id
1            1         1
2            1         2

How can i make something like

$company = Company::first();
$company->employees()->with('position')->get();

return only position associated with first user that belongs to first company as HasOne relationship?

Exactly which model you want to return? I don't really get what do you want to return — Cloud Soh Jun Fu
– Cloud Soh Jun Fu, Commented Mar 28, 2019 at 9:47
why are employees linked by user ids, and not employee_ids for example? — CodeBoyCode
– CodeBoyCode, Commented Mar 28, 2019 at 10:07
@CodeBoyCode There is not such thing as Employee model per se. Employee is simply User associated with Company. — platypusmaximus
– platypusmaximus, Commented Mar 28, 2019 at 10:10
@CloudSohJunFu I want to return all users that belongs to the company (that works already through many-to-many) and ONLY the POSITION associated with that specific company. — platypusmaximus
– platypusmaximus, Commented Mar 28, 2019 at 10:10
Make a relations to user and position in pivot_table model and one relation to pivot_table from Company model and then try Company::with(['pivot_table.user','pivot_table.position'])->first(); — Shubham Pokhriyal
– Shubham Pokhriyal, Commented Mar 28, 2019 at 11:25

Manisha · Accepted Answer · 2019-03-28 10:08:19Z

1

 Company.php     
    public function user() {
         return $this->belongsToMany('App\User', 'company_employees ', 'company_id', 
                    'user_id');
    }

    User.php
      public function position() {
            return $this->hasMany('App\Position');
        }


    $company = Company::with('user.position')->get();

edited Mar 28, 2019 at 10:08

answered Mar 28, 2019 at 9:57

Manisha

808 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

platypusmaximus Over a year ago

This doesn't solve a problem since user may have many positions. Although he can only have one position connected with a company.

platypusmaximus Over a year ago

Then it will return all user positions and not only those regarding company. $company->with('user.positions')->get() based on data from my question will resolve in company { User { position: { position at first company, position at second company } } }

Cloud Soh Jun Fu · Accepted Answer · 2019-03-28 10:27:23Z

0

I think you can only achieve it by using a custom with function.

Untested code:

$company = Company::first();
$company->employees()->with([
  'position' => function ($query) use ($company) {
    $query->where('company_id', $company->id);
  }
])->get();

Check out the documentation.

answered Mar 28, 2019 at 10:27

Cloud Soh Jun Fu

1,53211 silver badges15 bronze badges

Collectives™ on Stack Overflow

Laravel: Loading nested relationship only for related model

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related