Motrin (ibuprofen) and Tylenol (acetaminophen) are both effective for relieving UTI pain.  Pyridium (Azo), is also highly effective at relieving the pain and discomfort of a UTI.
Please note that pain relievers are not a substitute for UTI treatment. The infection could continue to spread while you take pain relievers. It is recommended to only take a pain reliever until you get your antibiotics and then go off the pain medication so you can monitor your symptoms and make sure the infection is gone.