how to fix up the sphere in my attach weapon


so here is the problem I want fix up the sphere when I swing the sword. It is horziontal, I want my sphere attach my sword . but I have no ideal how to fix it. thank you so much for helping

Similarly to how this persons attaches a weapon to a skeleton socket: - YouTube, you can do the same with a collision or sphere.

Thank you for replying, I try to fix up the position of the weapong socket. it did change, but the sphere itself is similar.