How can I get the parent id in the same line as the child ticket in an export of tickets?

how can you get an export from freshdesk where in the child tickets the ticket id of the parent item is also included? 

Now you only have the relation (parent or child) but when you have a child ticket, it would be useful to have the number of the parent ticket in the export for reporting purposes. Anyone has an idea?