Add regression test for nested meta path in json_normalize
We want to add regression test for #27220 and make sure that this kind of issues will not be present in the future.

Thanks to @yanglinlee [code](https://github.com/pandas-dev/pandas/pull/27667) I created test that works with current `master` branch.

- [x] closes #27220
- [x] tests added / passed
- [x] passes `black pandas`
- [x] passes `git diff upstream/master -u -- "*.py" | flake8 --diff`
- [x] whatsnew entry

thanks @LTe 