如何将“Join with Select语句结果”更改为“Laravel雄辩”?

我的问题是:

SELECT 
* 
FROM
(SELECT ks, COUNT(*) AS '# Tasks' FROM Table GROUP BY ks) t1 
INNER JOIN
(SELECT ks, COUNT(*) AS '# Late' FROM Table WHERE Age > Palt GROUP BY ks) t2
ON t1.ks = t2.ks

我想把它改成拉拉维尔雄辩。我需要使用Laravel雄辩的paginate方法

我试着这样做:

$query =  \DB::select(\DB::raw("
    SELECT *
    FROM (
        SELECT ks, COUNT(*) AS '# Tasks' FROM Table GROUP BY ks
    ) t1 
    INNER JOIN (
        SELECT ks, COUNT(*) AS '# Late' FROM Table WHERE Age > Palt GROUP BY ks
    ) t2 ON t1.ks = t2.ks 
"));

我很困惑 paginate 方法。我需要它。因为我要在视图中显示分页

脚本如下: {{ $results->appends(Request::query())->render() }}

我该怎么做?