PHP 分组依据并列出所有其他列

Question

我有一张 table :

选择的数据库是:

$select_table2 = '
SELECT e.product_clicks
     , e.product_id
     , e.website_url
     , u.name
     , u.product_id 
 FROM `oc_aa_affiliatecollclicktracking` AS e 
 LEFT      
 JOIN  `'.DB_PREFIX.'product_description` AS u 
    ON e.product_id = u.product_id 
 GROUP 
    BY e.website_url';

这会将其分组，但不会列出所有的product_id

我得到:

http://127.0.01
        36

我想对其进行分组，但查看所有的product_id

http://127.0.01
    36
    40
    33

Answer 1

$select_table2 = 'SELECT `product_id` FROM `oc_aa_affiliatecollclicktracking` WHERE website_url LIKE '%http%';

如果您不想重复product_id

$select_table2 = 'SELECT DISTINCT(`product_id`) FROM `oc_aa_affiliatecollclicktracking` WHERE website_url LIKE '%http%';