how to show a specific value for a non existing value in second table in join?
Use an outer join and replce NULLs using COALESCE:

SELECT C.city_name, COALESCE(CS.count_staff,0) AS count_staff
FROM City AS C 
LEFT OUTER JOIN count_staff_in_city AS CS ON C.city_id = CS.city_id;