You can minimize the burning by drinking lots and lots (some people find cranberry juice is particularly good for minimizing the pain) and peeing often - since that keeps the bacteria from building up so much.
You have to bite the bullet and go pee even though it hurts, then drink as much as you can bare and keep going to the bathroom often - it will hurt less that way.
Attention: NOTHING on this site may be reproduced in any fashion whatsoever without explicit consent (in writing) of the owner of said material, unless otherwise stated on the page where the content originated. Search engines are free to index and cache our content. Users who post their account names or personal information in their questions have no expectation of privacy beyond that point for anything they disclose. Questions are otherwise considered anonymous to the general public.