Finding the right "see-through" yoga pants usually falls into two categories: intentional fashion choices with mesh panels or unfortunate quality issues. If you are looking for stylish, intentionally sheer designs or trying to avoid "accidental" transparency, Where to Buy Intentional Sheer & Mesh Designs
How to prevent leggings from being see through? : r/Activewear
Known for their "Airbrush" and high-waist styles, they often incorporate mesh panels that provide a "studio-to-street" flair.
For a high-fashion, breathable look, these retailers offer yoga pants with strategic mesh panels or lightweight fabrics: