CSV of nodes with city name located in country


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: