备忘：laravel 对查询结果集可以循环where查询

laravel对get查询结果集可以foreach循环where查询

例如：
use App\Models\User\User;
use Carbon\Carbon;
use Carbon\CarbonPeriod;
$start_at=’2021-11-30’;
$end_at=’2021-12-01’;
$days = new CarbonPeriod($start_at, ‘1 days’, $end_at);
$user = User::selectRaw(‘date_format(created_at, “%Y-%m-%d”) as date, count(id) as count)
->whereBetween(‘created_at’, [$start_at, date(‘Y-m-d’, strtotime(“$end_at +1 days”))])
->groupBy(‘date’)
->orderBy(‘date’,’DESC’)
->get();
$result = [];
foreach ($days as $day) {
$user_count = $user->where(‘date’, $day->toDateString())->first();
$result[] = [
‘date’ => $day->toDateString(),
‘count’ => $user_count->count ?? 0
];
}
return $result;

本作品采用《CC 协议》，转载必须注明作者和本文链接