It shouldn't hurt anything, USB is designed so that you can't fry things (except for the good old USB-A to USB-A trick on Macbooks, that was nasty). The Wii may not put out enough power, so you might need to use a Y-Cable to actually supply enough power to the Pi though.