Laravel subquery with join. .

Laravel subquery with join. .