mysql操作查询结果case when then else end用法举例

public function getLMailList($map,$sort)
{
    $list = Db::name('leadermail')->alias('a')
        ->join('__ACCOUNT__ b', 'a.author_id = b.id', 'left')
        ->join('__SYSTEM_DICT__ c', 'a.category = c.code and c.type = 35', 'left')
        ->field('a.*,case a.open when 0 then "***" else b.name end as author,c.name as category')
        ->where($map)->order($sort);
    $re = $this->pageSelect($list);
    return $re;
}