这条sql语句怎么改成leftjoin的

'select app.*, u.username as creator, aty.name as type_name
from (select a.id, name, type, platform, appcatalog,packagename,
sortweight, a.status, iconpath, size, versionname,
versioncode, author, creator, to_char(a.created_at, \'YYYY-MM-DD HH24:MI:SS\')
as created_at, to_char(a.updated_at, \'YYYY-MM-DD HH24:MI:SS\') as updated_at
from applications as a, appversions as v where a.id = v.application
and v.id in (select max(id) from appversions group by application)
and deleted is null and a.organization = ? order by sortweight) as app
left join users as u on app.creator = u.id
left join apptypes as aty on app.type = aty.id'

怎么改写成laravel框架的left join的形式

select a.id, name, type, platform, appcatalog,packagename,
      sortweight, a.status, iconpath, size, versionname,
      versioncode, author, creator, to_char(a.created_at, \'YYYY-MM-DD HH24:MI:SS\')
      as created_at, to_char(a.updated_at, \'YYYY-MM-DD HH24:MI:SS\') as updated_at,
      u.username as creator, aty.name as type_name 
from applications as a 
   left join appversions as v  
         on a.id = v.application and v.id in (select max(id) from appversions group by application) 
   left join users as u on creator = u.id 
   left join apptypes as aty on type = aty.id
where deleted is null and a.organization = ? 
order by sortweight

select 表2.a as a,表2.a as b，表3.a as c from 表1 as a left join 表2 as b on a.条件（+）=b.条件 left join 表2 as c on a.条件（+）=c.条件 left join 表3 as d on d.条件（+）=c.条件