First determine whether the leak is due to clogging. Inject a very small amount of water into the small drainhole located near the front left corner of the sunroof cassette (open your sunroof and look in that area from the outside, you should be able to see a small hole in the side, about 2 inches back from the corner). If water drips out from behind your front wheelwell after doing this, the drain is -not- plugged.
However, it could very well be that the draintube from the front left corner of the sun/moonroof cassette is loose, i.e. not attached water-tight to the cassette nipple. If that is the case, nothing has to be clogged for it to leak water down through the driver-side A pillar and onto the dash and floorwell.
You can diagnose further by unscrewing all the bits (A pillar cover, ceiling handle, sunvisor & clip, central console stuff) and pulling the corner of your headliner down just enough to peek in. If it's loose, the draintube connector will have a drop or two of water or the area on/around it will feel damp. [If you do this, remove the negative cable from your battery as this area of the car has airbag hardware in there that you don't want to trigger.]
Fix is to re-attach the tube connector to the cassette nipple using some strong sealant like the Permatex stuff. Plus if you like you can loop a ziptie around that, but first you'll need to get in there and determine what you're dealing with.
DO NOT start sticking wires etc down into the sunroof drainhole; doing that can dislodge the draintube connection further down. Something more flexible (neoprene cord etc.) might be safer...
Just remembered another possibility.... Remove the drivers-side cabin air filter assembly (including the base, like you would if preparing to add brake fluid). Is that chamber full of water? If it is, you will need to feel down under the brake booster for a small nickel-size drainhole in the sheet metal and unclog it. Debris gets down in there somehow and if water accumulates, it can leak into the driver-side floorwell and also flood your brake booster and get water into your intake manifold from there.