使用 exists,或者not exists
SELECT
user_id
FROM
uc_user_organization
WHERE
NOT EXISTS (
SELECT
*
FROM
uc_user_student
WHERE
uc_user_student.user_id = uc_user_organization.user_id
)
AND uc_user_organization.role_id = '2300000001000000002'