select 
		m_cast.*,
		m_shop.name shop_name,
		m_shop.background_color,
		m_shop.color
		 from m_cast 
		LEFT JOIN m_shop
		ON m_shop.shop_id = m_cast.shop_id
		 WHERE  m_cast.del_login_id = 0 order by orderex