How to use inner joins with subqueries in Laravel 6 Eloquent

PHP Laravel Eloquent join with subquery