数据库是时间戳格式 ，要求查询数据按日期年月日格式分组,为什么查询出来还是按时间戳分组

你group by 的是 u.create_time

给你个参考吧

        $query = function ($query) use ($startAt, $endAt) {
            /** @var Builder $query */
            $success = NotificationSendRecordStatus::SUCCESS;
            return $query->select([
                'template_id',
                DB::raw('count(*) as send_records_count'),
                DB::raw("count(case when status = {$success} then 1 end) as send_success_records_count"),
                DB::raw("count(case when status <> {$success} then 1 end) as send_failed_records_count"),

                DB::raw('count(case when landing_times > 0 then 1 end) as landing_records_count'),
                DB::raw("date_format(created_at, '%Y-%m-%d') as created_date"),
                DB::raw('count(distinct user) as users_count'),
            ])->whereBetween('created_at', [$startAt, (clone $endAt)->endOfDay()])
                ->groupBy('template_id', DB::raw('created_date'));
        };

groupBy("from_unixtime(u.create_time,'%Y-%m-%d')")