How to sort by adjacent Laravel table?

Question

Laravel

Have a request

Card::leftJoin('comments', 'cards.id', '=', 'comments.card_id')
            ->select('cards.id')
            ->orderBy('comments.created_at', 'desc')
            ->groupBy('id')
            ->get();

Joinite, sorts by comment creation date and groups by card_id. But it groups incorrectly. I don’t understand where the error is ...
Query result:

Sorting in the database by creation date:

Answer 1

It turned out to be done through the filter as follows:

Card::leftJoin('comments', 'cards.id', '=', 'comments.card_id')
        ->where('comments.type', 'comment')
        ->select('cards.*')
        ->orderBy('comments.created_at', 'desc')
        ->groupBy('comments.id')
        ->get()
        ->filter(function($item, $key) {
            if(!in_array($item->id, $this->alreadySelectedCards)) {
                $this->alreadySelectedCards[] = $item->id;
                return true;
            }
        });

But this is a crutch and, it seems to me, there is a normal way to solve such a trivial problem...