mysql - 将 SELECT 查询从 mySql 转换为 Laravel 查询生成器

Question

这个mysql查询的Laravel Query Builder代码是什么；

SELECT * 
FROM Student
WHERE family_id IN (SELECT family_id 
                    FROM students 
                    GROUP BY family_id 
                    HAVING COUNT(1)>1)
ORDER BY family_id

Answer 1

$query = DB::select("SELECT * 
FROM Student
WHERE family_id IN (SELECT family_id 
                    FROM students 
                    GROUP BY family_id 
                    HAVING COUNT(1)>1)
ORDER BY family_id")

基于 Laravel Documentation