Normal association table query, we like to use the left join in statement, but when the database is large enough, the statement associated list when a query is more time consuming, the method of how to query more quickly and convenient query to the data