BUG: fix nested meta path bug (GH 27220)
- [x] closes #27220 
- [x] tests added / passed
- [x] passes `black pandas`
- [x] passes `git diff upstream/master -u -- "*.py" | flake8 --diff`
- [x] whatsnew entry

This PR attempts to solve the missing value problems when using nested meta with nested record path. 

The assumption is that we want to get the value of nested meta field even it is not on the record path. For example, in the example of GH 27220, ['info', 'governor'] and ['counties', 'name'] are not on the same path. The current behavior is to raise key error. I change the behavior to return the value of the key if we can find it in the json.

Let me know how we want to move forward with this. Thanks~