please help me to write this mysql code in laravel 5.1

[nasouti]

select *from jmeshposts join (SELECT jmeshposts.post_parent as tb1_id, jmeshposts.guid as image FROM jmeshposts where jmeshposts.post_status='inherit' and jmeshposts.post_type='attachment' ORDER BY jmeshposts.post_parent DESC) as table1 on jmeshposts.id= table1.tb1_id