// 创建分组字查询语句
$subQuery = $ActivityStatisticsModel->field('dept_id, sum(activity_num) as activity_num_total, sum(view_num) as view_num_total, sum(item_num) as item_num_total, sum(zan_num) as zan_num_total, sum(vote_num) as vote_num_total, create_time, update_time')
            ->group('dept_id')->buildSql();
// 组合查询，走正常查询逻辑，field中字段需要包含上面子查询字段
$list = $ActivityStatisticsModel->table($subQuery)
            ->with(['dept_info'])
            ->field('dept_id, activity_num_total, view_num_total, item_num_total, zan_num_total, vote_num_total, create_time, update_time')
            ->where($map)->where($map)->alias("d")->paginate($limit, false);