我有四张表:
- foods:id,name
- users:id,name
- mealtypes:id,name
- food_user:id,food_id,user_id,mealtype_id
foods和users之间有多对多的关系,mealtypes和food_user之间有一对一的关系
最终我想要一个具有以下属性的模型实例:food.name,users.name,mealtype.name
普通的SQL语句如下:
SELECT f.name, u.name, m.name FROM foods f
INNER JOIN food_user fu ON f.id = fu.food_id
INNER JOIN users u ON fu.id = u.id
INNER JOIN mealtypes m ON fu.mealtype_id = m.id
感谢您的任何帮助!