Hi team, can starrock limit resource such as memory, cpu assigned to each user when run query? for example user1 was assinged 10% mem, cpu, user2 was asigned 20% mem, cpu.

You might want to check out resource group. You can do something like this

create resource group sample_group to
(
user='user1',
)
with(
"exclusive_cpu_cores" = "4",
)

More details here: https://docs.starrocks.io/docs/administration/management/resource_management/resource_group/#enable-resource-groups