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 ;
原文:https://www.cnblogs.com/starmoon2019/p/9028293.html