I’m joining yarn with a magic sliding knot, I find that it doesn’t unravel at all, and you can trim the excess tails without having the knot falling apart. You can try it out: