GroupBy on relationship with same column name as parent

[igmltd]

Hi,

I have columns with the same name in both the parent table (Listings) and the related table (people), when i use groupBy it is using the 'area' column from the Parent rather than the relation, how can i get it to group by the relation 'area' column?

 $local_data = Listings::with('people')
                    ->where('email', $data['email'])
                    ->first();
                    
   $grouped_people = $local_data->people->groupBy('area');

Any help will be very much appreciated.

Thanks.

[chuckrincon]

Hey.

Try using the collection's groupBy function.

$localData = Listings::with('people')
            ->where('email', $data['email'])
            ->get();

$groupedPeople = $localData->groupBy(fn (array $item) => $item['people']['area']);

[ghost]

@chuckrincon the get returns instances of Listings in this case, not arrays.
$groupedPeople = $localData->groupBy(fn (Listings $item): int|float|string => $item['people']['area']);

[wizzymore]

$grouped_people = $local_data->people->groupBy('area');

This is completely valid and works, no matter the columns of parent for the people relationship are.