Get rows from database in laravel

Image one is "video_submission" table

Image one is "video_submission_transaction" table

I want to make group by job_no, same job_no should come under one group, how will be the laravel Query, from those two tables I should get 3 rows, both tables should have a join also,

via Chebli Mohamed