Sub-selects in Laravel Way

From Laravel 6, you can use addSelect() in Eloquent statement, and do some calculation to that added column.

1return Destination::addSelect(['last_flight' => Flight::select('name')
2    ->whereColumn('destination_id', 'destinations.id')
3    ->orderBy('arrived_at', 'desc')
4    ->limit(1)
5])->get();