You can‘t specify target table ‘t_user‘ for update in FROM clause

UPDATE t_user set UserPassword=(SELECT t.UserPassword from (select UserPassword FROM t_user where UserName='李四')t) where UserName='张三';