How To Get Value from three tables in mysql

I have three tables namely employees, company_cars, and delivery_locations
Each of these tables have two elements in common

for employees and company_cars we have employee_id, where employee_id is the driver of the car in company_cars table
employees table   cars table

for company_cars and delivery_locations we have car_id where car_id is the car used for delivering employees for a certain location….

Now I want to display the name of The driver the employees table from a car selected for a particular location.

I have tried the following but I can only get the employees id

$fetch_locations=mysqli_query($con,"SELECT *,
(SELECT car_name from company_cars as d WHERE r.selected_car = f.car_id) as bus,
(SELECT car_driver from company_cars as f WHERE r.selected_car = f.car_id) as driver
from delivery_locations as r order by name_of_location ASC LIMIT $start_from, $per_page_record");

Problem: Display name of Driver