Add more env vars and ability to run from root to "pnpm exec -r"

[geferon]

Contribution

• I'd be willing to implement this feature (contributing guide)

Describe the user story

I'm currently working on a monorepo where I need to run a command from the root of the repo with the subfolder of the workspace as a parameter, but this is not possible at all since pnpm exec -r only allows you to run a command from the workspace folder, and it only provides the PNPM_PACKAGE_NAME variable.

Describe the solution you'd like

It would be nice to add another parameter that runs each command from the root of the project and instead adds a variable like PNPM_PACKAGE_FOLDER with the subfolder of the project, so I can do something like:
-b, --base: Run commands from project root

pnpm -rcb "echo Project \$PNPM_PACKAGE_FOLDER"

Which would work like this in a project:
pnpm-workspace.yaml

packages:
  - example
  - apps/*

output:

Project ./example
Project ./apps/app1
Project ./apps/app2

Describe the drawbacks of your solution

I don't think this would imply many changes in the exec command since it would be adding a parameter and switching the cwd to the project root and adding a new env var to each command ran

Describe alternatives you've considered

My current alternative is to either parse the pnpm-workspace.yaml manually and run commands for each entry and parse wildcards, etc, or to find each package.json in subfolders and run a command for each of them, not the best options.

[fury0928]

@zkochan is this still valid issue?
I'd like to contribute for