如何联合两个case语句列

SELECT 
    order_id,
    customer_id,
    CASE 
        WHEN order_status = 'pending' THEN '待处理'
        WHEN order_status = 'shipped' THEN '已发货'
        ELSE '未知状态'
    END AS status_description,
    CASE 
        WHEN order_status = 'pending' THEN 'https://cloud.tencent.com/product/cvm'
        WHEN order_status = 'shipped' THEN 'https://cloud.tencent.com/product/cos'
        ELSE 'https://cloud.tencent.com'
    END AS product_link
FROM 
    orders;