Since it's a warning and not an error, it doesn't need to be fixed, but...
This is a warning thrown by node.js (which shouldn't be a surprise). I'm not sure if the standalone installer for sfdx includes node.js or not, but at any rate you have node.js and sfdx is using it.
NODE_TLS_REJECT_UNAUTHORIZED
is an environment variable (again, this shouldn't be a surprise, given the warning message). Having it set to 0 means that node.js is not verifying that the SSL/TLS certificates have a proper and unbroken path up to a trusted "root" certificate (again, the warning says this, so it shouldn't be a surprise).
Typically, you'd set this environment variable to '0' if your employer is using a proxy or has installed their own "root certificate" so they can decrypt your https traffic (which as I understand is fairly common practice).
If you are in that situation, then having NODE_TLS_REJECT_UNAUTHORIZED set to 0 is the easiest way to work around it.
If you aren't behind a proxy or have a company root cert installed, then getting rid of this warning is as simple as setting NODE_TLS_REJECT_UNAUTHORIZED to 1
.
From https://stackoverflow.com/questions/68592669/how-to-set-value-for-node-tls-reject-unauthorized-0-in-mac
export NODE_TLS_REJECT_UNAUTHORIZED=1 - Mac/Linux
set NODE_TLS_REJECT_UNAUTHORIZED=1 - Windows