Step 1: Rule.
The correct phrase is "afraid of" when expressing fear of something.
Step 2: Checking options.
(A) by — wrong.
(B) at — incorrect.
(C) of — correct: "afraid of ghosts."
(D) for — not suitable.
Step 3: Conclusion.
Correct answer is (C) of.