原生 sql 语句怎么转换成 Laravel 的查询构造器?
下面是我想要转换的sql语句
SELECT
*
FROM
categorys
LEFT JOIN
(
SELECT
category_id,
`status`,
count(status=1 or null) as "show",
count(status=2 or null) as "hide"
FROM
vocabularys
GROUP BY category_id
) t1
ON categorys.id = t1.category_id
where `categorys`.`user_id` = 19
order by `id` desc
推荐文章: