一个父行，另一个表中的多个子行。(One parent row, multiple child rows in another table. How to get them all in one row?)

 我是一名当地非营利组织的志愿者，在节日期间赠送玩具和食物。 我帮助他们的一种方式是在网上提出他们的礼物/食物要求。 这样，您可以在15个小时内手动将1000个左右的名称手动输入到Excel中，只需单击链接即可在几秒钟内导出整个内容。 
 
 我的问题与如何在一个查询中从数据库中获取数据有关。 我相信这是可能的，但不能完全包围我能做到的。 
 
 有一个父表，其中包含将收到礼物的孩子的家庭信息（每​​个家庭1行）。 有一个子表，其中包含家庭的孩子的信息（每个孩子1行，每个父行有很多行）。 每个父行将有1-3个子行。 
 
PARENT TABLE
-----------------------------
id
name
address
city

CHILDREN TABLE
-----------------------------
parent_id
name
gift1
gift2
gift3
 
 在从数据库导出数据时，我希望将所有孩子的信息与父母的信息一起获取，以便将其放入CSV文件中。 我知道我可以通过两个单独的查询来执行此操作，但如果可能的话，我不想为每个家庭的孩子访问数据库。 
 
 我已经思考了一个小时左右，并且无法想出我将如何实现这一目标。 我确定我需要加入这些表，但我不确定如何区分每个孩子并避免重复它们而不是让下一个孩子（如果有的话）。 

I volunteer for a local non-profit that gives out toys and food during the holiday season. One way that I am helping them is by putting their gift/food requests online. This way instead of manually entering 1,000 or so names manually into Excel over the course of 15 hours they can simply click on a link and have the whole thing exported in the matter of seconds.
 
My issue is related to how I can get the data from the database in one query. I believe it is possible but can't quite wrap my head around I can do it. 
 
There is a parent table which contains the family information for the kids who will receive gifts (1 row per family). There is a child table that contains the family's childrens' information (1 row per child, many rows for each parent row). There will be 1-3 children rows for each parent row.
 
PARENT TABLE
-----------------------------
id
name
address
city

CHILDREN TABLE
-----------------------------
parent_id
name
gift1
gift2
gift3
 
I would like to get all of the childrens' information with the parents' information in one row when exporting the data from the database so it can be put into a CSV file. I know I can do this with two separate queries but I don't want to hit the database for each and every family's children if possible.
 
I've pondered this for an hour or so and can't quite come up with how I would accomplish this. I'm sure I need to join the tables but I am unsure how to differentiate each child and avoid duplicating them instead of getting the next child (if there is one).

原文：https://stackoverflow.com/questions/3512948