select i.id, i.name, author.name, assigned.name from issues as i
join issues as author
  on i.author_id = author.id
join issues as assigned
  on i.assigned_to_id = assigned_to.id
where i.id = 1

SELECT
  i.id AS id,
  subject,
  s.name AS status_name,
  s.id AS status_id,
  i.assigned_to_id AS assigned_to_id,
  Concat(u.lastname, ' ', u.firstname, ' ', u.middlename) AS assigned_to,
  i.author_id AS author_id,
  Concat(a.lastname, ' ', a.firstname, ' ', a.middlename) AS author,
  i.due_date,
  i.start_date
FROM issues AS i 
JOIN issue_statuses AS s 
  ON s.id=i.status_id 
JOIN users AS u
  ON i.assigned_to_id=u.id
JOIN users AS a
  ON i.author_id=a.id
JOIN projects AS p
  ON i.project_id=p.id
WHERE 
  i.id = 12345;