Support for yarn pnp ESM resolver

[notpeelz]

Since nodejs/node#43772, I'm able to use the ts-node/esm loader on top of yarn pnp.

e.g: node -r ./.pnp.cjs --loader ./.pnp.loader.mjs --loader ts-node/esm ./test.mts,
It loads ts-node from ./yarn/cache/...ts-node.zip and runs test.mts as expected.
Tested on node v20.0.0-nightly2022122151246139e7.

However, ts-node's ESM loader doesn't resolve packages through yarn pnp.
Are there any other issues blocking this feature?

Parent: #1756
Related: #1007