原生 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