关于 mysql select 的问题

Question

需求：查询参加活动客户的信息列表，含客户参加次数。需用一条 sql实现。

$sql = "SELECT 
            *,
            (select count(*) from ".self::TABLE_JOIN." where join_status != '99' group by join_customer_id ) join_count
        FROM 
            ".self::TABLE_JOIN." 
        WHERE 
            join_status != '99'  
        ORDER BY 
            join_addtime DESC";

Answer 1

你没有给表结构，我是我程序里一条统计每个用户参于活动次数的统计，看能不能给你一点启示
select 
    info.uid,
    user.username,
    count(*) as total 
    from activity_info info  
    LEFT JOIN user_info user 
    on info.uid=user.id 
    where info.join_status != '99'  
    GROUP BY info.uid 
    order by info.join_addtime desc