How to perform a join containing a sub query on an Eloquent Relationship in laravel 6

PHP Laravel Eloquent join with subquery