How to avoid duplicate queries

I am using table with TextColumn, i am fetching custom data from another table based on the id of the $record. For some reason it gives me duplicate entries despite using callback. Any help please?

TextColumn::make('specialitie_id')
                    ->formatStateUsing(
                        fn($record) => Speciality::find($record->speciality->first()->parent_id, ['name'])
                        )
                ->label('Speciality'),

TextColumn::make('specialitie_id')
                    ->formatStateUsing(
                        fn($record) => Speciality::find($record->speciality->first()->parent_id, ['name'])
                        )
                ->label('Speciality'),

TextColumn::make('specialitie_id')
                    ->formatStateUsing(
                        fn($record) => Speciality::find($record->speciality->first()->parent_id, ['name'])
                        )
                ->label('Speciality'),

TextColumn::make('specialitie_id')
                    ->formatStateUsing(
                        fn($record) => Speciality::find($record->speciality->first()->parent_id, ['name'])
                        )
                ->label('Speciality'),

How to avoid duplicate queries

Similar Threads

Similar Threads

Similar Threads