Laravel sql select users email who listed rooms where status = listed

I have these 2 tables:

table users = id, name..

table rooms = user_id, title, status...

How can i select all users email who have published rooms where rooms status is Listed in Laravel 5 ?

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/2zOf9xx
via IFTTT