insert table referencing same table

[johnb8005]

{
    "err": {
        "message": "You can't specify target table 'faq_category' for update in FROM clause",
        "code": "ER_UPDATE_TABLE_USED",
        "errno": 1093,
        "sql": "INSERT INTO faq_category (`product_id`, `name`, `parent_id`, `uuid`) VALUES (2, 'General', (SELECT id FROM `faq_category` WHERE uuid='5ab20a92-db47-11ec-9500-42010aac0008'), UUID());",
        "sqlState": "HY000",
        "sqlMessage": "You can't specify target table 'faq_category' for update in FROM clause"
    }
}