Foreach in Inner Join

Question

Good afternoon, I have an sql query with Inner Join.

  $this->db->select('f.nome, f.sobrenome, h.habilidade');
  $this->db->from('funcionarios as f');
  $this->db->join('habilidades as h', 'f.id = h.id_funcionario');
  $query = $this->db->get();
  return $query->result();

The sql return is:

I need to list this return saying the name of the employee and the skills he has

But if I take and give a foreach like this:

foreach ($freelancers as $row){ 
  echo $row->nome; echo $row->sobrenome;
  echo $row->habilidade;
}

Then he picks up and prints the same person over and over again, which is natural.

My question is, what’s the best way to do that?

Note: I want to do in a way that is not to make 2 selects and use foreach inside of foreach with if.