bot-28/app/Support/MemberAccount.php

<?php

namespace App\Support;

use App\Models\User;

/**
 * 后台列表按会员账号(users.account)模糊筛选，适用于未 join users 的查询。
 */
class MemberAccount
{
    /** @param string $column 当前查询里的会员ID列 */
    public static function filter($query, $account, string $column = 'member_id')
    {
        $account = trim((string)$account);
        if ($account !== '') {
            $query->whereIn($column, User::query()->select('member_id')->where('account', 'like', '%' . $account . '%'));
        }
        return $query;
    }
}