It's highly unlikely that water has risen into the roof area from anywhere. The only remaining conclusion is that the drains are blocked or the seal is faulty around your sunroof. Do you have any idea if the sunroof is original fit or an aftermarket fit?
I'd probably look to a local, reputable sunroof fitter for advice.
To test the theory that water is getting in from outside, try colouring a watering can full with a little food colouring, then sprinkling it in specific places on the outside of the vehicle. You'll see if it makes it's way into the lining.