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~
@yanglinlee since we are dropping Python 3.5 very shortly, it may be best to skip the test on Python 3.5 by adding `@pytest.mark.skipif(not PY36, reason="...")` Do I need to make more changes to this PR? Thanks for the reviews! Fixed the merge conflict. Ping on green. @TomAugspurger The checks have passed. Now it is green.  @yanglinlee looks like a merge conflict and CI failure - mind taking a look? @yanglinlee i think the CI failure for the docbuild is unrelated.  can you re-push and we'll see if its fixed @yanglinlee we would take a patch like this if you want to update. closing as stale for now. 