I can’t think of any reason for that to not work other than that you have mistakenly used a bad field name… ie cms_page.name is not a valid reference. If you can reference menu.cms_page at all, then it should be returning a full AR model, and you should be able to use it like any other model.
If you could include the class definitions and maybe table definitions, might be able to help more.