The fireworks are over between Katy Perry and John Mayer! According to People, the musicians, who were first spotted together in June, went their separate ways. "They'll end up as friends," the source said on Aug. 23. "They were honestly having fun. People made it out to be far more than it was." Since her divorce from Russell Brand, the Part of Me singer, 27, was also linked to Florence + the Machine guitarist Robert Ackroyd. Mayer's exes, meanwhile, include Taylor Swift, Jennifer Aniston, Jennifer Love Hewitt and Jessica Simpson.