You can use something like this:
DataSet ds = ConnectionHelper.ExecuteQuery("SELET * FROM VIEW_CMS_TREE_JOINED", new QueryDataParameters(), QueryTypeEnum.SQLQuery);
I'd recommend creating some parameters though to make sure you filter your data properly. Any particular data you're trying to get? If you see a view for it, there is most likely an API call already created for you to use.