create new columns inner join laravel code example

Example 1: laravel find query

return Destination::orderByDesc(
    Flight::select('arrived_at')
        ->whereColumn('destination_id', 'destinations.id')
        ->orderBy('arrived_at', 'desc')
        ->limit(1)
)->get();

Example 2: laravel find query

$model = App\Models\Flight::where('legs', '>', 100)->firstOr(function () {
        // ...
});