laravel 7 problem iwant covert this code to laravel qurey

select id,house_name,(select TIMESTAMPDIFF(DAY,'2021-09-10',date_from) from bookings where house_id = houses.id order by id desc limit 1) as day_in from houses where id not in (select house_id from bookings where '2021-09-10' between date_from and date_to )

via Chebli Mohamed