Level 51
What exactly do you want to query? what data do you want to retrieve?
Oct 4, 2021
3
Level 1
Laravel Eloquent Relationship
I have this table / models:
lesson table and teacher table with pivot lesson_teacher table.
Then I have this registration table, with fields id, student_id, lesson_teacher_id.
And lastly, I have this student table
My question is what is the best way to query the relationships above.
Level 1
@MohamedTammam, I wanted to get the details of teachers, students and lessons using the registration table with fields lesson_teacher_id (Pivot table contains teacher and lesson id), student_id and etc.
Level 51
Look to (many to many)[https://laravel.com/docs/8.x/eloquent-relationships#many-to-many] relationship.
You need to have the following relationships:
- Many to many between student and lessons
- Many to many between teacher and lessons
To retrieve the details.
Student::with('lessons.teacher')->get();
PS: the code isn't tested.
Please or to participate in this conversation.