Get all childs per parent [on hold]

I have 3 entities: Country, City and Destination. Country is a parent of City and a parent of Destination.

I want to create a query that gives me a list of all countries with all their cities and destinations but I am stuck.

Can someone please help me out?