Something along these lines:
```
select distinct p.id, p.names
from Names p join Relation r on (p.id=r.id_parente)
join Names c on (c.id=r.id_child)
where c.names in ('George', 'Gordon');
```
Something along these lines:
```
select distinct p.id, p.names
from Names p join Relation r on (p.id=r.id_parente)
join Names c on (c.id=r.id_child)
where c.names in ('George', 'Gordon');
```