This is fairly common, it's in your head I used to pass out often because I was terrified of pins. Now I never pass out although I inject the same as always so for me the answer is obvious.
Just relax, put a fan on you and watch TV or something while you are getting poked, it helps keep your mind off of whats going on.
After time passes you will be able to stick yourself without issue, good luck.
LL