SQL Help：选择语句连接一对多关系

For example I have two tables. The first table is student while the second table are the courses that the a student is taking. How can I use a select statement so that I can see two columns student and courses so that the courses are separated by commas.For example I have two tables. The first table