查询语句:select * from courseware c left join user_cour uc on c.cid = uc.cid left join `user` u on uc.uid = u.uid where u.uid=1;
表格:user
user_cour
cour表格