SQL查询，检索邻接列表模型中某些类别下的所有产品

I have a database with an Adjacency List approach to handle categorization of products in which one product may be found under many categories. Get a look at the following database layout:I have a database with an Adjacency List approa