mysql的查找语句

select a.uid,a.month,a.coin,b.name from m_user_decroration_order as a
LEFT JOIN m_decroration_info as b on a.decroration_id = b.id where b.type = 5 ;

select a.uid,a.month,a.coin,b.name from m_user_decroration_order as a
LEFT JOIN m_decroration_info as b on a.decroration_id = b.id where b.type = 6 ;