create table person (
  id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  title enum('Dr','Miss', 'Mr', 'Mrs', 'Ms','Prof','Rev','Ven'),
  PRIMARY KEY(ID)
)ENGINE=INNODB;

create table friend (
  id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  fk_person_id INTEGER UNSIGNED,
  family_name VARCHAR(50),
  PRIMARY KEY (id),
  FOREIGN KEY (fk_person_id) REFERENCES person(id) ON DELETE NO ACTION
)ENGINE=INNODB;

SELECT p.id as person_id, f.family_name as friend_family_name, f.id as friend_id
FROM person AS p
JOIN friend AS f ON p.id = f.fk_person_id;

person_id      friend_family_name      friend_id
8              dimakopoulos            15
8              sotiropoulos            16
8              papadogkonas            17
9              zoumboulakis            18
9              zambolis                19
9              koula                   20

person_id      friend_family_name      friend_id      friend_family_name2      friend_id2      friend_family_name3      friend_id3
8              dimakopoulos            15             sotiropoulos             16              papadogkonas             17
9              zoumboulakis            18             zambolis                 19              koula                    20