PHP关联式JOIN笔记记录

如果一对多的话，如下

table--------------------table--------------------table
(user)---------------(shopcart)---------------(shop)

user.id-----> user_id------shop_id--------->shop.id
1 ---------------1---------------1---------------1
2 ---------------1---------------2---------------2
3 ---------------2---------------1---------------1

SELECT * FROM shopcart
INNER JOIN shop on shop_id = shop.id
WHERE user_id=:$SESSION['user]['id'];

找到一个方式以$SESSION储存过的使用者id来合併寻找