Feature Request: Static PIE support

**Describe the bug**
meson currently supports a `b_pie` option to build PIE executables.
There isn't an option for supporting the `-static-pie` option from gcc and clang.

**Expected behavior**
It would be desirable to have a `b_static_pie` option that enables the the `-static-pie` option on executables instead of just `-pie`.
Gives the user the option of having static-pie executables which may be desirable in some instances.

**system parameters**
This would be a feature for Linux operating systems. Not sure if MacOS supports this.

Start by tracing Meson's existing b_pie option and how it selects -pie for executables, then check the gcc and clang -static-pie behavior described in the issue. Done means a b_static_pie option enables static PIE executables on Linux without changing ordinary PIE behavior.

Written by the indexing model from the issue text.