How to Make Multiple Select Filters Combine with 'And' Logic Instead of 'Or' Logic?

SelectFilter::make('shipper_id')
    ->label('Shipper')
    ->query(function (Builder $query, array $data): Builder {
        $values = $data['values'];
        foreach ($values as $value) {
            $query = $query->orWhere('shippers.shipper_id', $value);
        }
        return $query;
    })
    ->options(Shipper::all()->pluck('shipper_name', 'shipper_id'))
    ->multiple(),

SelectFilter::make('clearance_agent_id')
    ->label('Clearance Agent')
    ->query(function (Builder $query, array $data): Builder {
        $values = $data['values'];

        foreach ($values as $value) {
            $query->orWhere('clearance_agents.clearance_agent_id', $value);
        }

        return $query;
    })
    ->options(ClearanceAgent::all()->pluck('clearance_agent_name', 'clearance_agent_id'))
    ->multiple();