Car Name, Zone name and Region Name

select
c.id as carid,
z.name as zonename,
cc.car_name as carname,
z.region as region

from cars as c

join car_classes as cc
on c.car_class_id = cc.id

join zones as z
on z.id = c.zone_id

join reservations as r
on r.car_id = c.id

join payments as p
on p.reservation_id = r.id

where CONVERT_TZ(c.created_at, '+00:00', '+8:00') <= '2019-1-31 00:00'

group by zonename,carname