Just wanna ask if the market have any compact camera with AI function like p40 pro camera? Auto edit photo, handheld night mode etc?

If your p40 pro ain't doing enough for you, the next best step up is a bigger sensor camera.

1 inch and above (sensor size) will see a significant upgrade vs phone cameras. Especially since you brought up night photography. Anything smaller than that will see no significant difference than the most advanced flagship smartphones. The only difference is probably better manual controls and optical zoom abilities

I recall back then..... When ppl bash all other sensor size for poor low light.... Only Full Frame are the best. Which logically and physically true.