select table in onther table laravel code example

Example 1: DB::table('users')->get(); id 1

$users = DB::table('users')where('id','=', $userid)->get();

Example 2: laravel find query

use App\Models\Destination;
use App\Models\Flight;

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