用where子句从多个表中进行雄辩的选择 - Laravel5 Eloquent select from multiple table with where clause

Laravel5 Eloquent select from multiple table with where clause

本文关键字：选择子句 where | 更新日期: 2023-09-27

如何在Laravel Eloquent中执行此查询?

SELECT * FROM `ftm_users`, `ftm_students`, `ftm_user_verification` WHERE `ftm_users`.`user_group` = 3 AND `ftm_user_verification`.`verification_status` = 1 AND `ftm_users`.`uid` = `ftm_students`.`uid` AND `ftm_users`.`uid` = `ftm_user_verification`.`uid`

我已经在模型中设置了关系，我已经尝试了这个

$userStudent = User::where('user_group', '=', 3)->with(array('userVerification' => function($query) {
        $query->where('verification_status', '=', 1);
    }, 'student', 'studentParents'))->simplePaginate(20);

，但是查询使用分隔的select语句从不同的表中获取数据。

谢谢。

假设您定义了ftm_users和ftm_user_verification之间的关系，您可以使用whereHas方法来过滤相关模型

$userStudent = User::where('user_group', '=', 3)->whereHas('userVerification', function ($query) {
    $query->where('verification_status', '=', 1);
})->get();

检查文档中关系是否存在