SELECT oa_type.name FROM oa_type
LEFT JOIN oa_mod ON oa_mod.classid=oa_type.classid
LEFT JOIN oa_role_mod ON oa_type.mod_id=oa_role_mod.mod_id
LEFT JOIN oa_user_role ON oa_role_mod.role_id=oa_user_role.role_id
WHERE oa_user_role.user_id='&user_id'
LEFT JOIN oa_mod ON oa_mod.classid=oa_type.classid
LEFT JOIN oa_role_mod ON oa_type.mod_id=oa_role_mod.mod_id
LEFT JOIN oa_user_role ON oa_role_mod.role_id=oa_user_role.role_id
WHERE oa_user_role.user_id='&user_id'
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货