hasManyThrough -Laravel5.8

Question

我的数据库表结构如下：

教室

• id (int) PK
• 名称(varchar)

ClassTeacherCourse

• id (int) PK
• id_classroom (int) FK
• id_teacher (int) FK
• id_course (int) FK

课程

• id (int) PK
• course_name (varchar)

教师

• id (int) PK
• teacher_name (varchar)

到目前为止，我只需要调用ClassRoom表& ClassTeacherCourse，如下所示：

$class = Class::find($id)
                 ->with(['classcourseteacher'])
                 ->get();

Class模型中的关系：

public function classcourseteacher() {
    return $this->hasMany('App\ClassCourseTeacher', 'id_class', 'id');
}

结果：

[
    {
        "id": 57,
        "id_school": 2,
        "class_name": "7 I",
        "classcourseteacher": [
            {
                "id": 406,
                "id_class": 57,
                "id_course": 9,
                "id_teacher": 68,
                "created_at": "2020-11-10 16:11:14",
                "updated_at": "2020-11-10 16:11:14"
            },
            {
                "id": 434,
                "id_class": 57,
                "id_course": 11,
                "id_teacher": 66,
                "created_at": "2020-11-10 16:11:14",
                "updated_at": "2020-11-10 16:11:14"
            },
        ]
    }
]

我读过雄辩:关系关于hasManyThrough的文章，但在文档中，情况与我不同。

如何通过口才打电话一次:与课程和老师的关系？

Answer 1

在ClassTeacherCourse课堂上放置教师与课程的关系

function teacher() {
    return $this->belongsTo(Teacher::class);
}

function course() {
    return $this->belongsTo(Course::class);
}

然后你就可以这样称呼它来获得细节

$class = Class::find($id)
             ->with(['classcourseteacher.teacher', 'classcourseteacher.course'])
             ->get();