There is no NPC named "Mushroom Maniac" in FireRed. The term is a community nickname for players who extensively farm TinyMushrooms / Big Mushrooms (from Paras/Parasect in Mt. Moon, etc.) to sell or craft.
Mushrooms are used for Revive crafting (Gen III) or sold for cash. No special trainer rewards mushroom farming.