You know the urine didn’t come from your vagina, right? It sounds like you focussed on the wrong hole.

Give yourself grace. Lots of people would’ve ended up in a fist-fight after that much alcohol. All you did was let others see your vulnerability. You’re human. This too shall pass.

What’s preventing you from saying exactly that? Why do you put up with the behaviour? This person finds you because you allow it in your life. Set some boundaries with yourself and with them. Be honest and tell them that their style of friendship weighs on you and it needs to change. If you can’t avoid them, you need them to change their behaviour. Or you need yourself to stop accepting it. But saying nothing about it to them hasn’t work for you so my advice is to discontinue your current strategy.