No it is not harmful to humans. This virus like most others others like it only infect plants. It is transmitted by aphids. So it survives inside of them but doesn’t replicate.

In watermelons it damages the new growth, especially the leaves. This reduces the plants ability to phosynthesize sugars and stops fruit production.