该句子不符合句法结构,有点中式英语的感觉,不符合英语的表达习惯,建议如下表达：
The student standing there is my good friend.
The student who is standing there is my good friend.