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

User 表有 first_name 而 teacherSubjects 有主题,如果它匹配 User 表中的 firstname 或 teacherSubject 中的主题,我想以这种方式放置条件


$teachers = User::with('teacherSubject')->whereHas('teacherSubject', function ($query) use($conditions){

                $query->where($conditions);

            })->get();


人到中年有点甜
浏览 118回答 2
2回答

慕雪6442864

试试这样:$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();

LEATH

你可以这样试试$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是要搜索的第一个名字。
打开App,查看更多内容
随时随地看视频慕课网APP