How do I collapse a result set in SQLite?

Let's say I have table

id name
1  nora
2  mars
3  ven

and I left join on id with this table,

id type     value
1  clothing shirt
1  clothing pants
1  toys     abacus
1  toys     legos
      ...

how do I produce something that looks like,

id name   clothing       toys
1  nora   shirt, pants   abacus, legos