查找记录属于主表或关系雄辩的ORM

Question

User 表有 first_name 而 teacherSubjects 有主题，如果它匹配 User 表中的 firstname 或 teacherSubject 中的主题，我想以这种方式放置条件$teachers = User::with('teacherSubject')->whereHas('teacherSubject', function ($query) use($conditions){                $query->where($conditions);            })->get();

Answer 1

试试这样：

$teachers = User::with('teacherSubject')

            ->where(function($query) use($name) {

              $query->where('first_name',$name);

                    ->orWhereHas('teacherSubject', function ($query1) use($name){

                        $query1->where('subject',$name);

                    });

            })

            ->get();

Answer 2

你可以这样试试

$teachers = User::where(function($sub) use($name) {

    $sub->where('first_name', $name)

    ->orWhereHas('teacherSubject', function($s) use($name) {

        $s->where('subject', $name);

    });

})whereHas('teacherSubject', function ($query) use($conditions){

$query->where($conditions);

})->with('teacherSubject')->get();

这$name是要搜索的第一个名字。