mysql> select u.id,u.user_name,u.active from cwd_user u  join cwd_membership m on u.id=m.child_user_id join cwd_group g on m.parent_id=g.id join cwd_directory d on d.id=g.directory_id where g.group_name = 'confluence-administrators' and d.directory_name='Confluence Internal Directory';

找到admin 的ID

+--------+----------------+--------+

| id     | user_name      | active |

+--------+----------------+--------+

| 229266 | admin          | T      |