用户表
关联用户表
注:user_id、 reviewed_id 对应用户表id
对应SQL
SELECT n.id,a.id,a.name,b.id,b.name from yl_meeting_leave n
LEFT JOIN yl_meeting_people a on n.user_id=a.id
LEFT JOIN yl_meeting_people b on n.reviewed_id=b.id
运行结果
用户表
关联用户表
注:user_id、 reviewed_id 对应用户表id
对应SQL
SELECT n.id,a.id,a.name,b.id,b.name from yl_meeting_leave n
LEFT JOIN yl_meeting_people a on n.user_id=a.id
LEFT JOIN yl_meeting_people b on n.reviewed_id=b.id
运行结果