Joining three tables

Last time I did something similar, I used either a foreach or I constructed a join using the query builder, depending on how important performance was.

But, there might be better ways to do this.

@pankaj No, there's no relation for this.

Describe what you want to achieve exactly and I'll tell you how.

@JarekTkaczyk company has many motortype and motorparts are specific to motortype so i want to get company's specific motortype ($this->belongsToMany('MotorType'); ) and its motorpart ( motorpart of motortype's returned by above relation )

same as Has Many Through but it has Many To Many relationship( motorType and MotorParts )

or for example @JarekTkaczyk

Student belongsToMany Semesters ( Inverse : Semester belongsToMany Students ) and Semesters hasMany Subjects ( Inverse : A Subject belongsTo Semester )

i want to get student's subject ( via their semester )

@pankaj

The easiest way for a specific company:

Company::with(['motorTypes.motorParts' => function ($q) use (&$parts) {
    $parts = $q->get()->unique();
}])->find($companyId);

if you have already fetched $company, then use $company->load(...) instead of with.

@JarekTkaczyk but wat would be database table structure for tat ?? how should i relate both (company and motorTypes) in MotorParts ?? i should add company_id and motortype_id in motorPart table ??

i tried ur above soln but it gives motorPart of which it doesnt belong to company( It should belong both to company and Motortype)

Ex : abcpart belongs to car and company1(both)

@pankaj You must describe it better. You have belongsToMany -> hasMany and with this the code will work.

Do you want to associate parts with companies as well or get parts of the company through types?

@JarekTkaczyk yeah i want to get parts of the company through types

@pankaj so my code above does exactly what you need.