How to add custom sort query?

TextColumn::make('groups.status')
                ->label('Status')
                ->sortable()
                ->formatStateUsing(function ($state, $record) {
                    $groupUser = $record->groups->where('id', group()->id)->first()?->pivot;
                    return $groupUser ? ucfirst($groupUser->status) : 'Inactive';
                })
                ->extraAttributes(['style' => 'font-weight: bold'])
                ->color(function ($state, $record) {
                    $groupUserStatus = $record->groups->where('id', group()->id)->first()?->pivot?->status ?? 'inactive';
                    return $groupUserStatus === 'active' ? 'success' : 'secondary';
                })