select city_name,dt,count(distinct driver_id) as driver_num
from driver_tb d
left join city_tb c
on d.city_id=c.city_id
where month(dt)=9
group by d.city_id,dt;