Searchable Has Many Issue

public function table(Table $table): Table
    {
        return $table
            ->query(InventoryLocation::query()->with([
                'userLocations' => function ($query) {
                    $query->latest()
                        ->take(1);
                },
            ]))
            ->columns([
                TextColumn::make('name')
                    ->getStateUsing(fn ($record) => $record->userLocations?->first()->data['name'] ?? $record->name)
                    ->label('Location Name')
                    ->searchable(query: function ($query, $search) {
                        $query->where('name', 'like', "%{$search}%");
                    })
                    ->sortable(),