thinkphp correlation model and attempted model difference

Correlation models are mainly used in multi-table operations, such as

User table, User_role table, role table

User_role field: Uid,rid, which acts as an intermediate table, is responsible for saving the 1-to-many, many-to-many relationships between user and role.

The correlation model is used when querying the user's data and all role data owned by the user through the UID.

The result of the role becomes a new array, inserted into the result array of the user, and becomes a multidimensional array.

The view model is the simplified operation of the MySQL join method.

The multiple tables are federated through the join method and then become a one-dimensional array output. There is no intermediate table one said! It is generally used as a select.

thinkphp correlation model and attempted model difference