SELECT
    p.gene_id AS parent_gene_id,
    c.gene_id AS child_gene_id,
    c.name    AS child_name
  FROM
    parent p LEFT JOIN child c ON (
      p.gene_id = c.gene_id
  )
  /* etc. */