User 表有 first_name 而 teacherSubjects 有主題，如果它匹配 User 表中的 firstname 或 teacherSubject 中的主題，我想以這種方式放置條件$teachers = User::with('teacherSubject')->whereHas('teacherSubject', function ($query) use($conditions){ $query->where($conditions); })->get();
2 回答
慕雪6442864
TA貢獻1812條經驗 獲得超5個贊
試試這樣：
$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
TA貢獻1936條經驗 獲得超7個贊
你可以這樣試試
$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是要搜索的第一個名字。
- 2 回答
- 0 關注
- 104 瀏覽
添加回答
舉報
0/150
提交
取消