SELECT u.name NAME, u.phone phone, i.level LEVEL, i.user_id, COUNT(1) total FROM t_user u,t_invitationcode i ,(SELECT COUNT(*),user_id FROM t_invitationcode it WHERE it.user_id=i.user_id) t3 WHERE u.id=i.user_id 不知道怎么写了
name
phone
level
user_id
id