Your sub query is returning more than one column. It should be returning only one column. That aside, I do not see a point of using sub query here. Shouldn't this give the result you expect:
SELECT ID, FIRSTNAME FROM HUMAN WHERE FATHERID=2
You should also try and read guidelines to ask question. Subject should be precise and not entire question itself.