CSV of nodes with city name located in country

Hello,

I need help with a query in Overpass (or similar service). It should be CSV output of nodes with name=“ABC” in country=“XYZ” and name of the city where the node is located. Some nodes but don’t have tag addr:city=.* or similar.

The CSV should look like something like this:
csv(id,type,name,city)