The microscopic appearance of xanthogranulomatous pyelonephritis shows many pale to foamy macrophages from breakdown of renal parenchyma with ongoing inflammation.