laravel 原始方法是否可以連接子查詢

表中存儲(chǔ)的數(shù)據(jù)顆粒度比較細(xì)，需要根據(jù)表中兩個(gè)字段做統(tǒng)計(jì)。

select B.col2,count(col2),sum(t.num)
from (
    select col1,col2,count(col3) as num
    from A
    where A.status = 1
    group by A.col2
) as t
left join B on t.col1 = B.col1
group by col1