widget query filter on related field

public function filtersForm(Form $form): Form
...
   Select::make('client_id')
     ->relationship(name:  'client', titleAttribute: 'name')
     ->options(function (?Model $record) {
         return Client::query()->pluck('name', 'id');
     }),
   Select::make('csm_id')->label('Customer Support Manager')
      ->options(User::where('customer_support_manager', true)->pluck('name', 'id')),

$client_id = (int) $this->filters['client_id'] ?? null;
$csm_id = (int) $this->filters['csm_id'] ?? null;
return $table
->query(
    $data = Campaign::query()
    ->with(['client'])
    ->where(function($query) use ($client_id){
        if ($client_id) {
            $query->where('client_id',  $client_id);
        }
    })
    ->where(function($query) use ($csm_id){
        if ($csm_id) {
            logger('CSM ' .$csm_id );
            // Tried several things here
            $query->where('customerSupportManager()', $csm_id);  // belongsToThrough
        }
    })
)
->columns([
    Tables\Columns\TextColumn::make('Status')
        ->summarize(Summarizer::make()
        ->using(fn (\Illuminate\Database\Query\Builder $query): string => $query->count('status')))
])
->groups([Group::make('status')])
->defaultGroup('status')->groupsOnly();

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'customerSupportManager()' in 'where clause'