title: How to select sub-query with left join inside using eloquent?
body: <p>I'm very new to Laravel, how can I make this query in Laravel using Eloquent model:</p>
  
  <pre class="lang-sql prettyprint-override"><code>SELECT
  (
    SELECT departments.deptname FROM school.counts
    LEFT JOIN reference.departments
    ON counts.departmentcode = department.departmentcode
    WHERE counts.countid = a.countsid
  ) AS departmentDesc
  FROM school.subjecthdr a
  LEFT JOIN school.subjectdtls b
  ON a.subjectid = b.subjectid;
  </code></pre>
  
  <p>I don't wish to use raw queries, is there any way? I still appreciate raw query suggestions if there's any.</p>