I'm new to Laravel and I wanted to convert the SQL query to laravel

I was trying to use EXCEPT method in Laravel but I was not able to get the result I wanted.

I'm using phpmyadmin and Laravel for my project and it was not hard for the previous few queries. Now I tried converting the following SQL but failed..

SELECT name FROM users 
EXCEPT 
SELECT name FROM `users` as us, main_user as ru WHERE ru.id=us.id;

The result is filtering the USERS table with not the ones present in MAIN_USER table. I would really appreciate the help..

via Chebli Mohamed