Is there a lock out switch on the drivers door that is engaged?
If not, check for power and ground at each rear motor. If the motor works, but there is grinding and binding, then you probably need rear window regulators.
RepairPal Certified shops can diagnose and repair your 2006 Mazda 6. They provide transparent pricing with a minimum 12-month or 12,000-mile warranty on repairs and services.