怎样解决一对多的数据查询?

有三个表 :

1. loss有字段(id,name)

2.loss_loss_cause(coupling table)连接(loss 和 loss_cause)表 有字段(loss_id,loss_cause_id)

3.loss_cause 有字段(loss_cause_id,name)

 

 

like :

in loss table:

id        name

1            a

2            b

3            c

 

 

in loss_loss_cause table:

loss_id        loss_cause_id

1                          1

1                          2

1                          3

2                          1

2                          3

3                          null

 

 

 

in loss_cause table:

loss_cause_id               name

1                                       lossCause_1

2                                       lossCause_2

3                                       lossCause_3

 

 

如何得到一个表,表里有loss_id, loss_cause_id ,loss.name,loss_cause.name

 

like:

loss_id      loss_cause_id   loss.name   loss_cause.name

1                1,2,3                     a             lossCause_1,lossCause_2,lossCause_3

2                1,3                        b             lossCause_1,lossCause_3

3                 null                       c               null