Your dream reflects a mix of personal desires, insecurities, and social dynamics. Here’s a breakdown of some key elements:

1. Piercing Shop/Studio Apartment: The piercing shop symbolizes a desire for transformation or change in your life, particularly regarding self-expression. The setting resembling a studio apartment could indicate a personal space where you're exploring your identity or relationships.
2. Flirting with the Male Piercer: Flirting often represents a desire for connection or intimacy. It might signify a longing for validation or attraction, possibly highlighting your confidence or insecurities in romantic situations.
3. Dermal Piercing: The dermal piercing in your dream may symbolize vulnerability, as piercings can represent a permanent mark or change. The fact that you could see it throughout the dream indicates that this change is significant to you. It could also point to a desire to show off a new aspect of yourself or your achievements.
4. Your Mom's Reaction: Your mom poking at the piercing could symbolize external judgment or criticism you fear regarding your choices or changes in life. This may indicate concerns about how your actions are perceived by those close to you.
5. Talent Show and Your Friend: The talent show represents a stage in your life where you want to shine or showcase your abilities. Your friend leaving without you could signify feelings of abandonment or the fear of being left out. It may also reflect concerns about support in your endeavors.
6. Frantic Search: Your frantic attempt to find a way to watch your friend perform could symbolize a desire to be involved, supported, or recognized in the social circles you care about. It reflects a struggle to find your place or voice in situations where you feel overshadowed.

Overall, this dream might be urging you to explore your identity, seek validation, and address feelings of insecurity in relationships or social situations. It could be beneficial to reflect on your current life circumstances and consider what changes you desire or how you might improve your connections with others.