56,679
社区成员
发帖
与我相关
我的任务
分享
SELECT
a.*, b.*, c.*, d.*
FROM
ns_member AS a
LEFT JOIN ns_member_account AS b ON a.uid = b.uid
LEFT JOIN tb_user AS c ON a.uid = c.user_id
LEFT JOIN ns_member_level AS d ON a.member_level = d.level_id
WHERE
1 = 1
AND c.user_status = 1
ORDER BY
a.reg_time DESC
LIMIT 0,
10