bot-28/app/Console/Commands/SyncUserLevels.php

<?php

namespace App\Console\Commands;

use App\Models\User;
use App\Services\BalanceLogService;
use Illuminate\Console\Command;

class SyncUserLevels extends Command
{
    protected $signature = 'users:sync-levels {--member= : Only this member_id}';
    protected $description = 'Raise users.level to match cumulative recharge (经验); never lowers a level';

    public function handle(): int
    {
        $query = User::query()->select('member_id')->orderBy('id');
        if ($member = $this->option('member')) $query->where('member_id', $member);
        $changed = 0;
        $query->chunk(500, function ($users) use (&$changed) {
            foreach ($users as $user) {
                [$before, $after] = BalanceLogService::syncLevel($user->member_id);
                if ($after === $before) continue;
                $changed++;
                $this->line("{$user->member_id}: {$before} -> {$after}");
            }
        });
        $this->info("updated {$changed} users");
        return self::SUCCESS;
    }
}