[RMVXACE] BEST WAY TO MAKE THIS?

If you want it to spin around in different directions like that, the only way to do it with pixel art is to manually create the animations by hand. Rendering it in 3D is another option, though, I guess. That is actually the way Chrono Trigger did it - it used the SNES's Mode 7 to render the 3D graphics. I haven't seen a Mode 7 script for RPG Maker that's capable of rendering anything more complex than a world map.

To just go in one direction would be much easier. You'd just need several images of different-sized stars being used as fog layers, moving at different speeds, with the smaller stars moving slower. If you're asking for "a script for generated stars or something" you're probably in over your head and should go with this simpler approach.

I'll point out that unless your space-travelling object is going at warp speed, this effect is actually pretty ridiculous. Lavos appears to be going over a billion times the speed of light in this cut scene, travelling dozens of light years every second. If you're making this scene for a starship then that's fine, but if it's for a meteor then you shouldn't really do this, you should use a fixed star background instead.