SELECT * FROM users 
WHERE users.id NOT IN ( SELECT users_id FROM user_type);

Explain:- This query fetches all user records from the users table but only keeps those whose ID is not found in the user_type table