为什么JoinSub中子语句的Having以及group 会出现在外面的主语句上。。。

期望执行

select 
    a.*
from table_name as a 
inner join 
(
    select 
        count(id) as total, user_id , MAX(create_time) as create_time 
    from table_name
    where order_status = 1
    group by user_id
     having total = 2
) as b on a.user_id = b.user_id and a.create_time = b.create_time;

代码

$subQuery = $builder->from('table_name')
            ->selectRaw('count(id) as total, user_id , MAX(create_time) as create_time')
            ->groupBy(['user_id'])
            ->havingRaw("total = {$times}");

$builder->from('table_name as a')->joinSub($subQuery,'b', function ($join) {
            $join->on('a.user_id', '=', 'b.user_id');
            $join->on('a.create_time', '=', 'b.create_time');
        });

Laravel 中打印的sql语句

Column not found: 1054 Unknown column 'total' in 'having clause' (SQL: select `a`.* from `table_name` as `a` inner join (select count(id) as total, user_id , MAX(create_time) as create_time from `table_name` as `a` group by `user_id` having total = 2) as `b` on `a`.`user_id` = `b`.`user_id` and `a`.`create_time` = `b`.`create_time` where 1 = 1 group by `user_id` having total = 2 order by `a`.`create_time`

![Laravel 子查询使用having的问题]

红色为疑惑位置。