Need a new air mattress

For information my wife and I are living in my mother in laws house and have to use an air mattress for a month or so until we find a new place. I currently have the king kook air mattress and it loses air every night. I’ve check the knobs and they are all closed but it happens constantly. I had and air mattress from Costco that put air back in it (form my memory) about 5 years ago and it was great but it got a puncture and I can’t find it now. Are there any good ones that keep air or that reinflate it automatically?