El código está copiado de César es el siguiente
delphi
public function get_Vendedores(){ self::set_names(); $sql ="select v.id_vendedor, v.nombre as vendedor,v.correo, v.telefono, s.nombre as supervisor from vendedor as v, supervisor as s where v.id_supervisor = s.id_supervisor order by v.id_supervisor desc"; foreach ($this -> dbh->query($sql) as $row){ $this->vendedor[]=$row; } return $this->vendedor; $this->dbh=null; }