SELECT p.*, u.username, u.nickname, u.avatar, c.name as category_name,
                       s.name as shop_name
                FROM pigeons p
                LEFT JOIN users u ON p.user_id = u.id
                LEFT JOIN categories c ON p.category_id = c.id
                LEFT JOIN shops s ON p.shop_id = s.id
                WHERE p.status = 1
                ORDER BY p.is_top DESC, p.created_at DESC
                LIMIT 12