Hi everyone.
I made this particle VFX in Unity 3D (URP) for The Tale of Bistun video game and used After Effects and Glue it software to animate and make a flipbook texture, also I used photoshop for the other textures.
I hope this tutorial was helpful.