NEW YORK - A backup musician for the alternative rock group, Smashing Pumpkins, was found dead of a drug overdose in a Manhattan hotel room early yesterday, police said. The body of the keyboard player, Jonathan Melvoin (34), was found at the Regency Hotel.