Export Parent and Child Table Data

How do I export Parent and Child Data into a single CSV file?

John Smith, Apples
John Smith, Oranges
John Smith, Grapes
Bob Dole, Apples
Bob Dole, Grapes