Drain the pineapple thoroughly, pressing it in a sieve to remove excess juice.
Whisk the mayonnaise, yogurt, honey, vinegar, salt, and pepper in a large bowl.
Add carrots, raisins, pineapple, and pecans if using. Fold until everything is coated.
Chill 20–30 minutes to meld flavors. Taste and adjust seasoning before serving.