Discuz! X 查询用户注册信息的情况
本帖最后由 Bruce.Kevin 于 2025-12-10 22:31 编辑查询用户的UID、用户名、用户组、管理组、扩展组、注册邮箱、注册时间及最后访问时间
SELECT
aa.`uid` AS UID,
aa.`username` AS 用户名,
bb.`grouptitle` AS 用户组,
(CASE WHEN aa.`adminid` = '0' THEN "无" ELSE bb.`grouptitle` END) AS 管理组,
(CASE WHEN aa.`extgroupids` = '' THEN "无" ELSE cc.`grouptitle` END) AS 扩展用户组,
aa.`email` AS 注册邮箱,
FROM_UNIXTIME (aa.`regdate`, '%Y年%m月%d日') AS 注册时间,
FROM_UNIXTIME (dd.`lastvisit`, '%Y年%m月%d日') AS 最后访问时间
FROM
pre_common_member aa
LEFT JOIN pre_common_usergroup bb
ON aa.`groupid` = bb.`groupid`
LEFT JOIN pre_common_usergroup cc
ON aa.`extgroupids` = cc.`groupid`
LEFT JOIN pre_common_member_status dd
ON aa.`uid` = dd.`uid`
LIMIT 10000
页:
[1]