HasMany Table Relationship pivot/group RelationManager

protected function getTableQuery()
return $this->record->submissions()->groupBy('session_id')->getQuery();
}

protected function getTableColumns(): array
{
$fieldNames = $this->record->submissions()
    ->pluck('field_name')
    ->unique();

$columns = [];

foreach ($fieldNames as $field) {
    $columns[] = TextColumn::make($field)
        ->label($field)
        ->getStateUsing(fn($record) => $this->getFieldValue($record, $field));
}

return $columns;
}

protected function getFieldValue(FormSubmissions $record, string $field)
{
return $record->where('session_id', $record->session_id)
    ->where('field_name', $field)
    ->value('field_value');
}

public function table(Table $table): Table
{
return $table
    ->query($this->getTableQuery())
    ->columns($this->getTableColumns())
    ->actions([
        DeleteAction::make()
            ->action(function (FormSubmissions $record) {
                FormSubmissions::where('session_id', $record->session_id)
                    ->where('form_id', $record->form_id)
                    ->delete();
            })
            ->requiresConfirmation()
            ->label('Delete'),
    ])
    ->bulkActions([
        BulkAction::make('deleteAll')
            ->action(function (Collection $records) {
                // Retrieve unique session IDs from the selected records
                $sessionIds = $records->pluck('session_id')->unique();

                // Delete all submissions related to these session IDs
                FormSubmissions::whereIn('session_id', $sessionIds)->delete();
            })
            ->requiresConfirmation()
            ->label('Delete All'),
    ]);
}

protected function getTableQuery()
return $this->record->submissions()->groupBy('session_id')->getQuery();
}

protected function getTableColumns(): array
{
$fieldNames = $this->record->submissions()
    ->pluck('field_name')
    ->unique();

$columns = [];

foreach ($fieldNames as $field) {
    $columns[] = TextColumn::make($field)
        ->label($field)
        ->getStateUsing(fn($record) => $this->getFieldValue($record, $field));
}

return $columns;
}

protected function getFieldValue(FormSubmissions $record, string $field)
{
return $record->where('session_id', $record->session_id)
    ->where('field_name', $field)
    ->value('field_value');
}

public function table(Table $table): Table
{
return $table
    ->query($this->getTableQuery())
    ->columns($this->getTableColumns())
    ->actions([
        DeleteAction::make()
            ->action(function (FormSubmissions $record) {
                FormSubmissions::where('session_id', $record->session_id)
                    ->where('form_id', $record->form_id)
                    ->delete();
            })
            ->requiresConfirmation()
            ->label('Delete'),
    ])
    ->bulkActions([
        BulkAction::make('deleteAll')
            ->action(function (Collection $records) {
                // Retrieve unique session IDs from the selected records
                $sessionIds = $records->pluck('session_id')->unique();

                // Delete all submissions related to these session IDs
                FormSubmissions::whereIn('session_id', $sessionIds)->delete();
            })
            ->requiresConfirmation()
            ->label('Delete All'),
    ]);
}