Here’s the plan. I know you already apologized, but take a step back, and a week or so away from everyone, and then comeback and apologize again, but tell them how you will change (like not drinking again) to ensure it doesn’t happen again. And tell them that you understand how they feel and you are willing to work on your relationships with them , and you know it will take time, but they are important to you and you hope that they will give you another chance. This type of genuine reflection on your actions, as well as a plan to improve in the future, are the ingredients for true everlasting friendship and show that you are serious. Good luck