how to get over it

You need to talk to someone to deal with this. Like a therapist. I can understand how scary the whole thing is, to the point where you dont even want to think about it (or think about thinking about it), but you do want to eventually have a relationship? There are few relationships that survive without any kind of physical intimacy… The earlier you deal with it, the better it will be. And you can deal with this…

Look, all phobias are magnified through aversive reactions which reinforce it… So for example, if you are bitten by a snake, and form a fear of snakes, you avoid anything to do with snakes, when you avoid say passing by the snake pit at the zoo, you feel a sense of relief, so then when you start seeing snake pictures, you start to feel a little anxious, so you start avoiding those, soon enough you’re scared of snake pictures too, and so on and so forth, till even thinking about snakes freaks you out… same kind of thing… and the only way to work through that is by not avoiding… you know how they say face your fears? well that’s how psychologists work with all fears… the thing is, if your fear doesnt even allow you to hear other people discuss it, you may actually need a therapist to help you get over that fear… and also, quite frankly, this is more than just about sex. There’s so much you have to deal with and process, and for your mental health and well-being, you really should talk to someone…

As for the friend thing, if you dont want to hear it, just say so… seriously, it isnt usually a big deal to most people…