How to handle the same table self-join subquery

I have a model as shown below:

class SysMenu(Model):
    id = fields.IntField(pk=True)
    pid = fields.IntField()
    name = fields.CharField(max_length=200)
    url = fields.CharField(max_length=200, null=True)
    permissions = fields.CharField(max_length=500, null=True)
    menu_type = fields.SmallIntField()
    icon = fields.CharField(max_length=50, null=True)
    sort = fields.IntField()

Question:
I want to implement the following sql query. I currently use raw sql to solve, but do not know how to use orm to solve?

select t1.*, (select name from sys_menu t2 where t2.id=t1.pid) as parentName from sys_menu t1 where t1.id = #{menu_id}

Does anyone know?

The issue provides only the SysMenu model and target SQL; no repository file, test, or entry point is named. Start by checking Tortoise ORM's documented query expressions, annotations, and self-reference support. Done would be a documented ORM approach for the parentName result, or a clear statement that raw SQL is required.