I don't fear needles per se I fear my body's reaction to them.
Fear of needles - Vasovagal - Wikipedia
My dad has the same thing, last time I had a physical I warned the nurses first, they did bloodwork and a booster shot at the end of my appointment, and someone had to monitor me for like 20m afterwards. They wouldn't let me stand up or leave for more than half an hour. Fucking sucks.
Ironically my coping method of deep breaths to calm myself is the worst thing to do, I read a medical journal story that described the best treatment being behavior similar to fighter pilots. Flexing the leg and arm muscles to artifically boost blood pressure to prevent the blood pressure crash and black out.
Weirdly enough, the only needles that don't cause any problem are Novocaine shots into my mouth, even though I can see the needle inches from my face it doesn't cause the same effect. My theory is the mouth is desensitized to the sensation of a needle from eating various hard/sharp/crunchy foods.