Find a European and American horror movie you saw as a child?

According to the information you provided, I did a search, and it was probably the American horror film "Fix the Card", 1989.

The background is indeed in a mental hospital, where three female inpatients jointly murdered a roommate, and then the murdered one turned into a ghost to get revenge. One of the female patients with glasses is in a wheelchair. In the climax of the film, the ghost did pierce her eyes with a steel pipe. The last scene seems to be a ghost jumping out of the cupboard and scaring the glasses girl.

Crazy Story is directed by bloody expert whitley and starring Peter Nichols. I believe it should be the movie you mentioned.

I hope I can give you some clues. If you are not sure, please provide more detailed information, and I will continue to try my best to help find the answer.