Inverse Relationship

This seems to be a simple question but I'm trying to figure it out.

I have the below Models


Student -> BelongsTo Course

Course -> BelongsToMany Teachers

Teacher-> BelongsToMany Courses

This means that Teacher is linked to Student via Courses

Now I want to pull the Students with Teachers

Thank you in advance for all your help.

Best Answer

Level 70

@jvbalcita if I understand you properly, you want to access student data from the teacher model.

In that case, you just simply use dot notation for Nested Eager Loading to access.

For example-

Teacher::with('courses.students')->get()

8 likes

Level 25

@jvbalcita or in case you want to retrieve only those Students that have a Course with Teachers you could do:

Students::has('course.teachers')->get();

3 likes

Level 102

Is it correct that a student can only ever have one course?

2 likes

Level 11

Yes we changed the grade level into course.

3 likes

Level 11

Thank you @marianomoreyra this works too.

3 likes

Level 11

@tisuchi, this one works. thank you!

3 likes

Please or to participate in this conversation.