• 
  
  // count括号里带统计条件
  
  
• 
  
  
  
  
• 
  
  SELECT user_id,count(type=1 or null) donate_num,count(type=2 or null) rent_num
  
  
• 
  
  FROM ot_dynamic  
  
  
• 
  
  GROUP BY user_id
  
  
  

奈斯，感谢分享