Is there any way I can help my 10 year old son make friends?

He is very energetic and comes on strong to people. He is just like his dad. They're both extremely outgoing friendly people that have no friends. I don't understand it. My son has one friend and my son says he's an oddball (which is fine) but why is my son only drawn to him? He says others make fun of him. Lately, he's been kind of moping around and I'm terrified he'll end up doing the things his dad does (drugs, drinking, sleeping around) to become popular. I have him in sports and he doesn't seem to like it. He's involved in church. Is there anything else I can do?