```select u.username, u.uid, u.directory from user...
# macos
a
Copy code
select u.username, u.uid, u.directory from users u, (select * from user_groups where gid = '80') g where u.uid = g.uid and u.uid != '0';