SELECT 
  a.work_id,
  a.school_id,
  a.per_id,
  a.title,
  a.detail_short,
  a.detail,
  a.file1,
  a.file2,
  a.post_date,
  a.read_count,
  b.per_id,
  b.position_id,
  b.fullname,
  b.`position`,
  b.phone,
  b.email,
  b.file1 AS file1_person,
  (Select position_name from m_position c Where b.position_id = c.position_id) AS position_name
FROM
  s_workteacher a,s_person b
WHERE
  a.work_id = '2303' AND (a.per_id = b.per_id)