`STR_TO_DATE` fail to parse 'Tuesday, 23 May 2023' for '%W, %d %M %Y'

## Bug Report

Please answer these questions before submitting your issue. Thanks!

### 1. Minimal reproduce step (Required)

### 2. What did you expect to see? (Required)

```
mysql> SELECT STR_TO_DATE('Tuesday, 23 May 2023', '%W, %d %M %Y');
+-----------------------------------------------------+
| STR_TO_DATE('Tuesday, 23 May 2023', '%W, %d %M %Y') |
+-----------------------------------------------------+
| 2023-05-23 |
+-----------------------------------------------------+
1 row in set (0.00 sec)
```

### 3. What did you see instead (Required)

```
mysql> SELECT STR_TO_DATE('Tuesday, 23 May 2023', '%W, %d %M %Y');
+-----------------------------------------------------+
| STR_TO_DATE('Tuesday, 23 May 2023', '%W, %d %M %Y') |
+-----------------------------------------------------+
| NULL |
+-----------------------------------------------------+
1 row in set, 1 warning (0.00 sec)

mysql> show warnings;
+---------+------+-------------------------------------------------+
| Level | Code | Message |
+---------+------+-------------------------------------------------+
| Warning | 1292 | Incorrect datetime value: '0000-00-00 00:00:00' |
+---------+------+-------------------------------------------------+
1 row in set (0.00 sec)
```

### 4. What is your TiDB version? (Required)