SELECT user.user.account AS user_name, user.role_binding.uid AS user_id, user.role.name AS role_name, user.role.id AS role_id
FROM user.user
JOIN user.role_binding ON user.user.uid = user.role_binding.uid
JOIN user.role ON user.role_binding.role_id = user.role.id
WHERE user.user.account = "admin";

SELECT u.account, rb.uid, r.name, r.id
FROM user.user u
JOIN user.role_binding rb ON u.uid = rb.uid
JOIN user.role r ON rb.role_id = r.id
WHERE u.account = "admin";