多表联合查询的sql语句

header("Content-Type:application/json;charset=utf-8");require("conn.inc.php");@$hid = $_REQUEST['hid'] or die('{"msg":"hid is required"}');$sql = "SELECT * FROM kkf_community WHERE cid=(SELECT cid FROM kkf_house_con WHERE hid=$hid)";$result = mysqli_query($conn,$sql);$row = mysqli_fetch_assoc($result);echo(json_encode($row));