易优会员升级列表显示

                {eyou:sql sql='SELECT ul.level_name,um.money,um.add_time,u.nickname,u.head_pic FROM __PREFIX__users_money AS um LEFT JOIN __PREFIX__users AS u on um.users_id = u.users_id LEFT JOIN __PREFIX__users_level AS ul on ul.level_id = um.level_id WHERE um.cause_type = 0 AND um.status = 2' LIMIT 10 ORDER BY um.moneyid DESC cachetime='-1'}<li><img src="{$field.head_pic}"><a><strong>{$field.nickname}</strong><em>￥{$field.money}</em>升级了<span>{$field.level_name}</span><i>[{$field.add_time|MyDate='Y-m-d H:i:s',###}]</i></a></li>{/eyou:sql}