关联表如何进行多条件联合查询

For example, there are two tables, User and UserInfo. User has two fields, isVip and userInfo, and User and UserInfo have a one-to-one relationship. UserInfo has an age field. Now, how can we query data where the age is greater than 30 and isVip is true, and return all the Users? We have read many articles online that mention using the JOIN table.field method to make the comparison, but we have tried various methods and received the error message "column not recognized."