That animation can be played like any other animation called by a script (I used it in my EMOTES mod) but to be honest it doesn't look that great. Their arms glitch into their bodies and legs despite sitting properly on the ground.
The name of the animation is Sit_Campfire_01
CharacterSetAnimationOverride(_Char,"Sit_Campfire_01");