Children with unrealistic perceptions of their academic abilities can harm their relationships at school, according to a recent study.