The "user joined" sound is a standard 3-second clip categorized under the uncategorized tag. Added to the library by yuuzinha, it currently has 27 plays and serves as a great unique addition to customize your stream.

Add this directly to your channel point rewards, or integrate it into the Creati Extension to let viewers trigger it with Bits.