SOLR establishes a many-to-many object index that only displays the first one when retrieved

The commodity table is a many-to-many relationship with the region table, and there is an intermediate table between them iyb_commodity_distribut_region establishes the relationship.

Now the Solr-data-config configuration is as follows:

query= "Select Cd.region_sid, c.* from iyb_commodity C left joins Iyb_commodity_distribut_region CD on cd.commodity_s id = c.sid where C.rank > -1 "

The result is the following demo data:

Ask for expert guidance

Now there's the problem:

You see, Region_sid is 328488 and 328493 for the 1 commodity .

However, when executing in SOLR query, you only get one piece of data:

SOLR establishes a many-to-many object index that only displays the first one when retrieved