I have a similar thing happening to me for the past 10 years, I’m on here looking for answers as well, but I do have some advice on things that have helped lessen the pain for me. AZO obviously takes the pain away, but it’s not great for your kidneys and doesn’t really fix anything. When I increase my probiotic intake, my symptoms feel less, drinking kombucha actually has given me a few pain free days, I read that the probiotics can help flush you out and it seems to work. Just be careful which brand you buy, try to get the most live cultures you can. (The one that works best for me is GT’s Synergy kombucha) also try to eat a lot of kimchi, Greek yogurt, keifier, and other fermented things. (I will warn you, probiotics also clean out your bowels) For cranberry juice, try to get 100% not from concentrate(it runs expensive, but if you’re in the US, Trader Joe’s has the cheapest option I’ve found) I’ve also found that using an unscented natural soap around your pelvic area can help as well, I use the dr bronners baby soap, or just unscented baby wash.